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?

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