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.
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...
Add TT for AM/PM:
'M/D/YYYY h:mm:ss TT'
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.
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).
Retrieving data ...