My date showing number format I need convert date format?

[gkcchowdary]

Hi

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

[tresesco · Accepted solution]

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

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

[YoussefBelloum]

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