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.
Solved! Go to Solution.
hi jdunkerley79
Do you have by chance the formula to convert Date to JDE and Epoch to Date ?
The opposite formulas.
Thanks
Juan