Convert SAS numeric date to an Alteryx date field.

[acolburn1]

Hello. I am trying to convert a SAS numeric date (the number of days since 1/1/1960) into an alteryx date field for use in my workflow. I have tried doing this: DateTimeAdd(DateTimeParse('1-1-1960','%m-%d-%Y'),[EXP_DT],"days") where [EXP_DT] is my numeric date, or number of days to be added.

But it tells me that the second argument should not be a number.

Let me know if you have any ideas.

Thanks!

[Qiu · Accepted solution]

@acolburn1 
First time to know SAS numeric date.

I tried your formula and it works just fine on my end.

So maybe we should check if the input  [EXP_DT] is really a numeric field or not.

[acolburn1]

Yep, forgot to reformat as an integer. Thanks for the reply!

[Qiu]

@acolburn1 

Glad to help and thank you for the accept mark!