Discussion Board for collaboration on QlikView Scripting.
I'm trying to create some courier delivery codes from timestamps but am struggling to figure out the correct date/time functions to use.
So for example, if a timestamp has a time part of 9am, the delivery code is '9AM'. Similarly, if a timestamp is before 12pm (and not equal to 9am) then the code is 'AM'.
For the 9am code I have tried a few things like the below but none of them give the expected result....
If(Time(Timestamp(PromisedDelivery, 'hh:mm')) = MakeTime(9), '9AM', 'Other')
Can anyone point me in the right direction?
Go to Solution.
as timestamp is a number
you could do something like
if find it much more easy to compare two integers
Brilliant. Thank you!! :-)