Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I need to calculate number of days and buckets as shown bellow with respect to following to dates:
Advanced | 0-30 | 31-45 | >45 |
---|---|---|---|
eg.Before Posting Date | eg.Between Posting Date and Due date | eg.After Due Date + 15 days | eg. Due Date +15 days |
Thanks & Regards,
Kshitija
You can try something like this:
IF (
Interval(Date1-Date2,'d') < 0 , 'Advanced',
IF ( Interval(Date1-Date2,'d') <= 30 , '0-30',
IF ( Interval(Date1-Date2,'d') <= 45 , '31-45',
'>45'))) as [buckets group],
Hi,
Share your sample data with excel/text format. tks