Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

djegatheesan
New Contributor

Date & Timestamp

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:MMSmiley FrustratedS.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

1 Reply
Highlighted

Re: Date & Timestamp

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]

Community Browser