Forum Discussion
android1
Post Patron
Post PatronConvert json DateTime format
Hi, How do I convert a column containing a date and time in the json format to DateTime. My dates are like this /Date(1457355600000)
I was referring to change your query name so that your table name in the data model doesn't have the GUID and such in it and ? and such.
How I can convert this format "2019-10-14T19:46:53.2751336Z" to "2019-10-14 19:46:53"?
Thaks!
Anonymous try cleaning the column with the Clean function on the ribbon. It worked for me.