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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.