Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am a beginner to qlikview and read some docs related to date & timestamp but having some doubts on it. Can you please clarify.
I am getting the source format as YYYY-MM-DD HH:MM:SS.FFF and my SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT', in this particular case do i need to convert the source as timestamp using timestamp# as my set timestamp format is different. Thanks for your input.
Regards,
Jegatheesan
Yup, you'll need something like :
TimeStamp ( TimeStamp# ( [YourTimeStamp] .'YYYY-MM-DD hh:mm:ss.fff' , 'M/D/YYYY h:mm:ss.fff tt' )
[above typed freehand so may have typo's]