Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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
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.
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
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.
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;