topic convert date text to data type date using DAX in DAX Commands and Tips

convert date text to data type date using DAX

theglamgamer — Fri, 23 Jun 2023 16:08:13 GMT

Having issue converting this date text to data type date:

Feb 3, 2021 12:00:00 EST

I tried using Date Format = DATEVALUE and

DATEVALUE(FORMAT(Details[Plugin Modification Date],"MMM/DD/YYYY HH:MM:SS EST"))

I created a new column to test those 2 functions but get a text couldn't convert to date type error

Re: convert date text to data type date using DAX

tamerj1 — Fri, 23 Jun 2023 16:22:57 GMT

Hi theglamgamer

please try CONVERT - DATETIME. otherwise it will be complex 😅

Re: convert date text to data type date using DAX

theglamgamer — Mon, 26 Jun 2023 14:35:49 GMT

Can you share an example? 🙂

Re: convert date text to data type date using DAX

tamerj1 — Mon, 26 Jun 2023 15:06:49 GMT

theglamgamer

Column = CONVERT ( LEFT ( 'Table'[Date], 12 ), DATETIME )

Also DATEVALUE + LEFT should work

Column = DATEVALUE ( LEFT ( 'Table'[Date], 12 ) )