How to calculate # of days between 2 days

[5tac3y111]

Hi, 

My start date is in the data format dd/MM/yyyy, but the end date is in the format MM/yyyy. In this case, how shall I calculate the # of days between the start and end date? 

Also, how to add dd to my end date? assuming using the first day of the month. 

Thank you.

[Felipe_Ribeir0]

Hi @5tac3y111 

You can use this formula

datetimediff(datetimeparse([enddate], '%m/%Y'), datetimeparse([startdate], '%d/%m/%Y'), 'days')

[grazitti_sapna]

@5tac3y111 , here is a complete workflow if this is what you needed. You can firstly convert your dates to datetime format supported by Alteryx using DateTime tool and then find the difference.