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...
As long as you're fine with precision of days you can use the Date.AddDays function, for instance as shown below.
= Table.AddColumn(#"Previous step", "New column name", each Date.AddDays(#date(1970,1,1),Int32.From(Number.FromText(Text.BetweenDelimiters([JsonDateColumn],"/Date(",")/"))/24/3600/1000)))