Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
If(Today()-DueDate <= 30, '0-30 Days',
If(Today()-DueDate <= 60, '31-60 Days',
If(Today()-DueDate <= 90, '61-90 Days',
If(Today()-DueDate <= 120, '91-120 Days',
Due Date |
22-02-2018 |
10-05-2017 |
26-10-2016 |
05-08-2020 |
05-04-2019 |
12-11-2022 |
12-03-2021 |
20-05-2020 |
09-04-2020 |
10-01-2020 |
07-09-2020 |
Can someone please help on this as its really much needed?
Thanks
try below
if(DueDate>= today() or len(trim(DueDate))=0,'Active',
If(Today()-DueDate <= 30, '0-30 Days',
If(Today()-DueDate <= 60, '31-60 Days',
If(Today()-DueDate <= 90, '61-90 Days',
If(Today()-DueDate <= 120, '91-120 Days',
If(Today()-DueDate <= 150,'121-150 Days', 'Over 150'))))))
try below
if(DueDate>= today() or len(trim(DueDate))=0,'Active',
If(Today()-DueDate <= 30, '0-30 Days',
If(Today()-DueDate <= 60, '31-60 Days',
If(Today()-DueDate <= 90, '61-90 Days',
If(Today()-DueDate <= 120, '91-120 Days',
If(Today()-DueDate <= 150,'121-150 Days', 'Over 150'))))))
Hi,
Can you please attach sample app?
Thanks
Hi Kush,
Thanks for your help in this, it working now !!
Please mark appropriate answer as correct to close this thread