I have to back by subtracting it

[Sshasnk]

So Basically I have to take the date which is 366 days from below given date

Example:

Date

31/12/2022

Date2 = Date - 366

Output

Date	Date2
31/12/2022	31/12/2021

[ChrisTX]

Try a Formula tool with:   DateTimeAdd([your date], -366, "days")

Here's a list of all functions: Functions | Alteryx Help

Chris

[binuacs]

@Sshasnk 

[ShankerV]

Hi @Sshasnk 

One way of doing this.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @Sshasnk 

Step 1: Input

Step 2: DateTime tool, as 31/12/2022 is not alteryx date format. Wanted to convert to YYYY/MM/DD.

Step 3: Formula tool

DateTimeAdd([Date1A], -366, "days")

Step4: Select tool to format the output

Output:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

hi @Sshasnk 

One more way to reach the exact output as you are expecting.

Output

Date	Date2
31/12/2022	31/12/2021

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

@Sshasnk 

Step 1: Input

Step 2: DateTime tool

Step 3: Formula tool

Step 4; Select tool

Step 5: Text to columns tool

Step 6; Formula tool

[3]+"/"+[2]+"/"+[1]

Step 7: Select tool

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V