topic Re: Set specific timestamp as variable in QlikView

Set specific timestamp as variable

Anonymous — Mon, 26 Jan 2026 21:26:37 GMT

Can you please help me out, how to set timestamp as variable, the format that I need is 5/13/2014 5:00:00 PM.

Thanks

Surender

martinpedersen — Wed, 14 May 2014 14:56:39 GMT

Hi Surender,

Try adding this in your load script:

Let TimeStamp1 = Timestamp(Now(), 'M/D/YYYY h:mm:ss');

Set TimeStamp2 = Timestamp(Now(), 'M/D/YYYY h:mm:ss');

Reload and explore the variables...

Anonymous — Wed, 14 May 2014 15:07:13 GMT

Add TT for AM/PM:

'M/D/YYYY h:mm:ss TT'

Anonymous — Wed, 14 May 2014 17:26:31 GMT

I mean, I want to put a condition in my expression, where I want records greater than 5/13/2004 5;00:00 PM

I am trying to set this timestamp in variable and use that variable in expression, pl advise.

Thanks,

Surender

Anonymous — Wed, 14 May 2014 17:32:53 GMT

For this specific timestamp, the variable definition is:

=timestamp(timestamp#('5/13/2004 5:00:00 PM', 'M/D/YYYY h:mm:ss TT'))

If you use it for the comparison, format doesn't matter (unless it is in set analysis where format does matter).