Creating a new column with date

[Gaetano_B]

hi all,

I have a column A made of a date, 14/10/2020 and I need to create column B which is equal to col A-30, so B would be 14/9/2020. I have tried a formula but it doesn't seem to work. Any suggestions?

Many thanks,

Gaetano

[Emil_Kos · Accepted solution]

Hi @Gaetano_B,

Make sure your date is in actual date format. When that will be sorted please use this formula

DateTimeAdd([Column_name],-30,"days")

If this is something helpful please mark as solved!

[mceleavey · Accepted solution]

Hi @Gaetano_B ,

try this in a formula:

datetimeadd(<Column A>,-30,"Days")

Hope this helps.

M.

[JosephSerpis · Accepted solution]

Hi @Gaetano_B I mocked up a workflow let me know what you think? I included two formulas one for 30 days and one for a month which will give a different data for months more or less than 30 days.

[atcodedog05 · Accepted solution]

Hi @Gaetano_B 

Here is a workflow for the task. I am assuming when you say A-30 you meant A-30 days

only yyyy-mm-dd is Alteryx accepted date format.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @Gaetano_B 

Cheers and Happy Analyzing 😀