AnsweredAssumed Answered

Conditional formatting of date

Question asked by dkensinger on Oct 11, 2012
Latest reply on Oct 11, 2012 by dkensinger

Title

Conditional formatting of date

Post

     I'd like to format a date field like this:

     if the date is less than 60 days from today, show the dd-mmm-yyyy

     if the date is less than 1 year away and greater than 60 days from today, show the mmm-yyyy

     if the date is more than a year from today, show Q1-yyyy, Q2-yyyy etc.

     Can this be done with a script or function?

     Dave

Outcomes