topic Re: Issue in generating dates in QlikView

Issue in generating dates

riyazasma1009 — Thu, 20 Apr 2017 12:53:31 GMT

Hi,

I have written a simple script wherein I am generating dates.

LOAD Date;
LOAD Date(($(vStartDate) + RecNo()),'MM/DD/YYYY') as Date
AutoGenerate vEndDate - vStartDate;

After running the script, the Date field contains values from 12/31/1899 to 12/29/1900.

However, I wish to generate all the dates between 1/1/2017 to 12/31/2017. Can someone please help me as to where I am going wrong.

Thanks,

Asma

Re: Issue in generating dates

kaushiknsolanki — Thu, 20 Apr 2017 12:55:24 GMT

Hi,

Make sure that the vStartDate variable has got the correct date in number format.

Regards,

Kaushik Solanki

Re: Issue in generating dates

Anonymous — Thu, 20 Apr 2017 13:02:04 GMT

Hey, could you show what vStartdate contains?

May be it is problem with the format of your variable

Re: Issue in generating dates

riyazasma1009 — Thu, 20 Apr 2017 13:29:37 GMT

I have created start date and end date variables s:

LET vStartDate = MakeDate(2017,1,1);
LET vEndDate = MakeDate(2017,12,31);

Re: Issue in generating dates

kaushiknsolanki — Thu, 20 Apr 2017 13:31:51 GMT

Hi convert them to number.

Let vStartDate = num(makedate(2017,1,1,));

Let vEndDate = num(makedate(2017,12,31));

Regards,

Kaushik Solanki

Re: Issue in generating dates

riyazasma1009 — Mon, 24 Apr 2017 12:33:08 GMT

Thanks Kaushik for the solution!

Re: Issue in generating dates

riyazasma1009 — Tue, 25 Apr 2017 07:01:28 GMT

Can someone please as to why the below code returns only value 01/01/2017 in Date field.

LOAD Date,
Month(Date) as Month,
Year(Date) as Year;
LOAD Date($(vStartDate) + RowNo(),'DD/MM/YYYY') as Date
AutoGenerate vEndDate - vStartDate;