topic Re: Date Script not converting integer correctly in QlikView

Date Script not converting integer correctly

jonathanrichey — Sat, 16 Nov 2024 04:59:41 GMT

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.

Re: Date Script not converting integer correctly

Mark_Little — Tue, 11 Dec 2018 14:08:24 GMT

Hi,

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

Mark

Re: Date Script not converting integer correctly

Somasundaram — Tue, 11 Dec 2018 14:09:42 GMT

Use this,

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

Re: Date Script not converting integer correctly

jonathanrichey — Tue, 11 Dec 2018 14:14:59 GMT

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