I am trying to get a field to show either Priority Normal, Priority high or Priority Critical depending on how far away from today the “manufactured by” date field is.
ie. if 3 weeks away priority normal
if 2 weeks away priority high
If 1 week away priority critical
Aby help would be greatly appreciated.