Date Script not converting integer correctly

[jonathanrichey]

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.

[Mark_Little · Accepted solution]

Hi,

Try
Date(Date#(PrioritizedDateKey,'YYYYMMDD')'YYYY/MM/DD')

Mark

[Somasundaram]

Use this,

Date(Date#(PrioritizedDateKey,'YYYYMMDD')'YYYY/MM/DD')

[jonathanrichey]

To simple. I overlooked it. Thanks for your assistance!