This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i have date field,
I want to convert this milliseconds to Date and Time format.
12/04/2016 01:34:23 AM
14/05/2016 05:34:23 PM
I tried with all expressions, its not working. pls help me to find out.
May be like this in your environmental variable
SET TimestampFormat='DD/MM/YYYY hh:mm:ss TT';
and then just TimeStamp(Date) as Date in the load statement
View solution in original post
how is 233.2323 becoming 12/04/2016? I might be missing something, but it would be great if you can elaborate and then we might be able to help better
Sorry, i haven't actually posted the exact milliseconds, that converts to 12/04/2016.
i meant that just as a sample.
Try using the below expression:
=Date(Date#(date,'ss.fff'),'M/D/YYYY h:mm:ss[.fff] TT')
or simply use