To get end date from start date

[Polite123]

Hello team,

Need some suggestion regarding below issue.Please help

Input:

Start Date

1/1/2021

2/1/2021

3/1/2021

4/1/2021

5/1/2021

6/1/2021

7/1/2021

8/1/2021

9/1/2021

10/1/2021

11/1/2021

12/1/2021

Output:

Start Date	End Date
1/1/2021	1/31/2021
2/1/2021	2/28/2021
3/1/2021	3/31/2021
4/1/2021	4/30/2021
5/1/2021	5/31/2021
6/1/2021	6/30/2021
7/1/2021	7/31/2021
8/1/2021	8/31/2021
9/1/2021	9/30/2021
10/1/2021	10/31/2021
11/1/2021	11/30/2021
12/1/2021	12/31/2021

Thnaks in advance.

[PhilipMannering]

Hi @Polite123 ,

You can use this Formula,

DateTimeFormat(DateTimeAdd(DateTimeAdd(datetimeparse([Start Date], '%m/%d/%Y'), 1, 'month'), -1, 'day'),
'%m/%d/%Y')

[AngelosPachis]

Hi @Polite123,

You can use the datetimetrim function after you convert your input to a format that Alteryx can understand as a date.

Regards,

Angelos

[messi007]

@Polite123,

Please see below:

Attached the workflow,

Regards,

[Polite123]

Amazing!! Thank you both you for your prompt response.

Much appreciated.Thanks again.