Hi Guys,
Can anyone help me how to convert Unix Ephoc time to actual time, this is is because i need to calculate the days difference between two ephoc date fields.
I found this in a post: https://community.alteryx.com/t5/Data-Preparation-Blending/Does-Alteryx-allow-you-to-convert-Unix-Epoch-time-to-another/m-p/13432#M2462
Unix Epoch time is number of seconds since '1970-01-01 00:00:00'The function DATETIMEADD() is what you needDATETIMEADD('1970-01-01 00:00:00', [Unix Epoch Time], 'seconds')
@michael_treadwell solved it
DATETIMEADD('1970-01-01 00:00:00', [Unix Epoch Time], 'seconds')
This above format is not working.. What should be value in [Unix Epoch Time]
