Does Alteryx allow you to convert Unix Epoch time to another date format?

[Dom]

Does Alteryx allow you to convert Unix Epoch time to another date format?

[Inactive User]

Awesome ..Thank you..!

[AKPWZ]

Hi @bobpeers 

I have one query related to unix/epoch time conversion.

I'm using this formula to convert this unix/epoch time into normal date time format but it throwing an error - 

Error - "Error: Formula (23): Parse Error at char(38): Formula: tried to apply numeric operator to string value (Expression #1)
"

Formula: DateTimeAdd('1970-01-01',[created_at]/1000, 'Seconds')

Can you please help me what wrong I'm doing here?

[#4]

I have one query related to unix/epoch time conversion.

I'm using this formula to convert this unix/epoch time into normal date time format but it throwing an error - 

Error - "Error: Formula (23): Parse Error at char(38): Formula: tried to apply numeric operator to string value (Expression #1)
"

Formula: DateTimeAdd('1970-01-01',[created_at]/1000, 'Seconds')

Can you please help me what wrong I'm doing here?

[bobpeers]

Hi @AKPWZ 

My guess would be that your field [created_at] is formatted as a string instead of a number.

[AKPWZ]

Hi @bobpeers  Thank you it worked for me when I change the data type to double before dividing it. Thanks alot!