convert the field to a date field

dandaanilreddy — Sat, 16 Nov 2024 04:43:41 GMT

Hello ,

I have a field in which i have the values like below. I want to convert this as a date field. Can someone help me ?

Tue Jul 23 16:03:36 BST 2019

Wed Feb 20 21:28:59 GMT 2019

Thanks

Re: convert the field to a date field

Vegar — Mon, 09 Sep 2019 20:41:52 GMT

You can do it in the script like this:

LOAD MyTimestamp, makedate( SubField(MyTimestamp,' ' , -1), //Year Month(date#(SubField(MyTimestamp,' ' , 2), 'MMM')), //Month SubField(MyTimestamp,' ' , 3) //Date ) as MyDate Inline [ MyTimestamp Tue Jul 23 16:03:36 BST 2019 Wed Feb 20 21:28:59 GMT 2019 ];

Or as a measure in the chart like this.

=makedate( SubField(MyTimestamp,' ' , -1), //Year Month(date#(SubField(MyTimestamp,' ' , 2), 'MMM')), //Month SubField(MyTimestamp,' ' , 3) //Date )

topic Re: convert the field to a date field in App Development

convert the field to a date field

Re: convert the field to a date field