Create Status based of date field

[Rachel_Ivory]

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.

[Kamille_Parks]

Try:

IF(
   DATETIME_DIFF(
      {Manufactured By},
      TODAY(),
      'days'
   ) < 8,
   "priority critical",
   IF(
      DATETIME_DIFF(
         {Manufactured By},
         TODAY(),
         'days'
      ) < 15,
      "priority high",
      "normal"
   )
)