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.
Hi @5tac3y111
You can use this formula
datetimediff(datetimeparse([enddate], '%m/%Y'), datetimeparse([startdate], '%d/%m/%Y'), 'days')
@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.