DateTimeNow=DateTimeNow()
EpochStartTime='1970-01-01 00:00:00'
EpochTime=DateTimeDiff([DateTimeNow],[EpochStartTime],"Seconds")
1
C:\ProgramData\Alteryx\Engine\Engine_804152_33bfbed0002e4df4a34a54e4e458d0c4\Engine_659888_aeb4b36fe9f74abba6f8d27726a619ca.yxdb
Single
Table
DateTime=DateTimeAdd('1970-01-01',[EpochTime],'seconds')
C:\ProgramData\Alteryx\Engine\Engine_804152_33bfbed0002e4df4a34a54e4e458d0c4\Engine_659888_2d71f0a218214fc193aac2b05a8eee23.yxdb
Single
Table
1427963684
Get Current Epoch Time
Convert Epoch Time Stamp to Human Time
DateTime=DateTimeDiff([Date],'1900-01-01','days')+2
C:\ProgramData\Alteryx\Engine\Engine_804152_33bfbed0002e4df4a34a54e4e458d0c4\Engine_659888_91ba9e4f26ba4d2591cd22edcaf3ac96.yxdb
Single
Table
2015-04-02
Get Excel Serial Time (post 1904)
DateTime=DateTimeAdd('1900-01-01',[Date]-2,'days')
C:\ProgramData\Alteryx\Engine\Engine_804152_33bfbed0002e4df4a34a54e4e458d0c4\Engine_659888_2a36cd6ab916471bb5c11882df1769f3.yxdb
Single
Table
42096
Convert Excel Serial Date to Human Date (post 1904)
Vertical
excel serial number to date