Convert SAS numeric date to an Alteryx date field.

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!

Parse

Date Time

Accepted answers

@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.

1203-acolburn1.yxmd

All comments

@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.

1203-acolburn1.yxmd

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

Quick Links

Tags

This months top contributors