dayend function not working

[srihitha]

Can someone please explain why a1 is empty

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';
a1:
LOAD dayend('25/01/2013 16:45:00',0,0.5) AutoGenerate 1;

[vchuprina · Accepted solution]

Hi,

Your timestamp format doesn’t match your date

Change it from

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';

to
SET TimestampFormat='DD/MM/YYYY h:mm:ss';

a1:
LOAD
     dayend('25/01/2013 16:45:00',0,0.5) AS DayEnd
AutoGenerate 1;

Regards,

Vitalii

[Vegar · Accepted solution]

Your TimestampFormat variable tells us that your default timestamp format is expected to contains AM or PM.

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';

Try changing your variable like this.

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]';

Then your timestamp '25/01/2013 16:45:00' should be handled correctly.

[Vegar]

Alternative solution

If you can't change your TimestampFormat then you can enforce Qlik to interpret your timestam even if it uses a different pattern. Try this. It should work.

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';

a1:

LOAD dayend(Timestamp#( '25/01/2013 16:45:00', 'DD/MM/YYYY h:mm:ss') ,0,0.5) AutoGenerate 1;