topic Re: My date showing number format I need convert date format? in QlikView

My date showing number format I need convert date format?

gkcchowdary — Wed, 25 Nov 2020 16:16:04 GMT

I have date field and my data showing number format like. 42703.6106944444

42703.628217593

How to convert to date field.i need two ways

1)only date like 5/17/2018

2)with time stamp 5/17/2018 01:35:22 like that.

Thanks

tresB — Tue, 22 May 2018 10:14:32 GMT

Date(Floor(<number>), 'MM/DD/YYYY') - for date only

Timestamp(<number>, 'MM/DD/YYYY hh:mm:ss') - for timestamp detail

YoussefBelloum — Tue, 22 May 2018 10:14:38 GMT

Hi,

if you're loading a timestamp field with the format described above, you can try this:

Timestamp(Timestamp#(your_field,'M/DD/YYYY hh:mm:ss'),'M/DD/YYYY hh:mm:ss') as the_name_you_want