Hi,
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.
Try:
IF(
DATETIME_DIFF(
{Manufactured By},
TODAY(),
'days'
) < 8,
"priority critical",
IF(
DATETIME_DIFF(
{Manufactured By},
TODAY(),
'days'
) < 15,
"priority high",
"normal"
)
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.