Cordeiro82
MIS
Hello All,
I have a future orders table that contains a date field [datedue]. The table is refreshed everyday, and the dates begin with the day of the refresh onwards.
I would like to create an additional field that is populated with the following text:
"Today" for min[datedue] (which would also be the day of the refresh)
"1" to "4" for the next 4 dates, and ">4" for all dates after that.
Any help or nudge in the right direction would be extremely helpful.
Thanks,
Cordeiro82
I have a future orders table that contains a date field [datedue]. The table is refreshed everyday, and the dates begin with the day of the refresh onwards.
I would like to create an additional field that is populated with the following text:
"Today" for min[datedue] (which would also be the day of the refresh)
"1" to "4" for the next 4 dates, and ">4" for all dates after that.
Any help or nudge in the right direction would be extremely helpful.
Thanks,
Cordeiro82