AnsweredAssumed Answered

Result based on days between two dates

Question asked by jackmac on May 18, 2018
Latest reply on May 18, 2018 by philmodjunk

Hi,

 

I have a field 'DateRendered' which is the date created .  I want the system to look at that date and compare to today's date. If it's less than 30 days put nothing.  If more than 30 but less than 60 put 'More than 30'.  If it's more than 60 put 'More than 60".

 

I've created a CASE statement but it only returns a blank, a1 or a 0.  What am I missing anyone:

 

Case ( (Get ( CurrentDate ) - DateRendered) < 30 ; "";

(Get ( CurrentDate ) - DateRendered) > 30 ; "More than 30" and (Get (CurrentDate ) - DateRendered) < 60; (Get ( CurrentDate ) - DateRendered) > 60 ; "More than 60")

 

Nay help much appreciated!

 

Using FM Pro Adv 15

 

TIA

 

Jackmac

Outcomes