JDE Julian Date Converter to Timestamp in milliseconds converter

[kirangottu]

Pls help me in converting 
JDE Julian Date to Timestamp in milliseconds convertesion in alteryx

Below is the sample record

125365--Convert to JDE Julian Date Converter
(http://peoplesoft.macek.cc/dateconverter.php?)
Result:YYYY/MM/DD:2025/12/31
Convert to epochconverter
https://www.epochconverter.com/ 

Timestamp in milliseconds: 1767139200000

My source value is date=125365 and target should be loaded as tridate=1767139200000

(This is sample value I need to test for 1000 of records  ) so pls send me the work flow assuming Date as source column and tridate as target column.

[jdunkerley79 · Accepted solution]

A couple of formulae should do it:

JDE => Date:

DATETIMEADD(TOSTRING(FLOOR([Date]/1000)+1900)+"-01-01",MOD([Date],1000)-1,"days")

and then Date to Epoch:

DateTimeDiff([ParsedDate],"1970-01-01","seconds")*1000

Sample attached to get you going.

[Juda]

hi jdunkerley79

Do you have by chance the formula to convert Date to JDE  and Epoch to Date ?

The opposite formulas.

Thanks

Juan