DATETIMEADD function returning the same value for all epoch inputs

Hi everyone! New to alteryx, running my first set of workflows. I'm trying to input a set of epoch values to convert to a regular timestamp but the results are the same regardless of the input? Attaching screen grabsworkflow for datetimeadd Output Output here

Preparation

Expression

Accepted answers

mborriero

Could you please try to rename your last time_in_seconds with another name and use it in the DATETIMEADD formula?

It is just a test, it seems a strage case

All comments

ivoller

Hi,

Does Time_Output have the correct data type (String Size 19)?

mborriero

@shivraj_r could you please take a screenshot of your full formula?

Are you using 'second' as third parameter of the datetimeadd function?

Are you sure you are using the correct field time in second/100 and not the old one?

I have tried it and it works for me.

See picture attached

DateTimeAdd.PNG

shivraj_r

@mborriero - Attaching screen shot of my formula here - The interesting thing is that it works as as standalone offline solution (attached solution) but it doesn't work when I try to pull data from a database. And if you notice even the output from the function does not give me the correct response. formula formulaworkflowofflineworkflow_sample

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703