Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date that is loaded as an Integer in the following format YYYYMMDD. The date function does not convert correctly. Is there an additional step I am missing?
I have set the date:
SET DateFormat='YYYY/MM/DD';
Load statement:
DateHelper: Load //*, PrioritizedDateKey, date(MonthStart([PrioritizedDateKey])) as DateHelperMonthYear, Date(PrioritizedDateKey,'YYYY/MM/DD') as comeatme, Year(Date#(PrioritizedDateKey,'YYYY/MM/DD')) as DateHelperYear
Resident ComeAtMeTable;
The image shows the result after the load.
Use this,
Date(Date#(PrioritizedDateKey,'YYYYMMDD')'YYYY/MM/DD')