How to calculate # of days between 2 days
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
5tac3y111
5 - Atom
‎11-30-2022
03:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Date Time
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
‎11-30-2022
03:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @5tac3y111
You can use this formula
datetimediff(datetimeparse([enddate], '%m/%Y'), datetimeparse([startdate], '%d/%m/%Y'), 'days')
grazitti_sapna
17 - Castor
‎11-30-2022
08:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
Sapna Gupta
