Forum Discussion
Converting JSON to Date/Time
Hi, Trying to convert a 13 digit JSON date column to date/time. In Edit Query I change my JSON column,["Column1.Date - Copy"] to whole number. I get 1.45731E+12 (1 example). I create a custom co...
In case anyone else needs a simpler solution, this is what worked for me.
#"Add Column" = Table.AddColumn(#",Previous Step Name", "<new column name>", each (#datetime(1970, 1, 1, 0, 0, 0 ) + #duration(0, 0, 0, [<field to change>]+36000/1000))),