First. You need to ensure that you can interpret the date values as date. If they aren't date values then you can do this: date#(OrderDate, 'DD-MMM-YY')
Second You need to identify your comparison date. I assume you want to compare with today's date You can use today()
Third: To get the no of days between your OrderDate and your comparison date use subtraction, like this:
today () - date#(OrderDate, 'DD-MMM-YY')
Fourth. Bucket your date diff. You can do this using an nested if statement or using interval match. For this example I'll use an nestled if statement like this.
First. You need to ensure that you can interpret the date values as date. If they aren't date values then you can do this: date#(OrderDate, 'DD-MMM-YY')
Second You need to identify your comparison date. I assume you want to compare with today's date You can use today()
Third: To get the no of days between your OrderDate and your comparison date use subtraction, like this:
today () - date#(OrderDate, 'DD-MMM-YY')
Fourth. Bucket your date diff. You can do this using an nested if statement or using interval match. For this example I'll use an nestled if statement like this.
