I need to create a calculated field to convert timestamp to datetime. The current column does not give a date with mm/dd/yyyy. Any thoughts on this?
Note: Data is connected live. DATEPARSE function doesn't work (it has to be an extract).
Can't you split using this
SPLIT(STR(Open Date)," ")
Hi Chris ,
Go to your data source page and change the data type to date.You can change this from your worksheet as well .
I'll test it out. Thanks Deepak!
Retrieving data ...