Date & Timestamp

[Anonymous]

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

[Anonymous]

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]