I'm doing a date change analysis to understand how many days a sales order delivery date is changed up or out. I have the change from and change to dates. Anyone know of a way to incorporate the day of week? Ex, changed from monday to tuesday?
Page 1 / 1
Hello @anne.molle ,
REMAP_VALUES(TO_STRING(DAY_OF_WEEK("LFA1"."TS_ERDAT")), ,'0', 'Sunday'], ,'1', 'Monday'], ,'2', 'Tuesday'], ,'3', 'Wednesday'], ,'4', 'Thursday'], ,'5', 'Friday'], ,'6', 'Saturday'])
Above example assume TS_ERDAT already in date format. Hope help!
Hi Teuku, thanks for this suggestion! 😀 Anne
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.