Forum Discussion

android1's avatar
android1
Post Patron
10 years ago

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...
Need Help
android1's avatar
android1
Post Patron
10 years ago

Hi,

 

Thanks for the reply. I have zero knowledge of PQFL. In Curt's code what do I need to change to 

make it applicable to me? Is the let Json.Date the column that contains the JSON date in my table?

 

Thanks