AnsweredAssumed Answered

Get(CurrentDate)

Question asked by MargoAnn on Aug 28, 2011
Latest reply on Aug 28, 2011 by LaRetta_1

Title

Get(CurrentDate)

Post

I have created a field called Current Semester with the calulation

If (Get ( CurrentDate ) ≥ Date ( 7 ; 1 ; Year ( Get ( CurrentDate ) )) and Get ( CurrentDate ) ≤ Date ( 12 ; 31 ; Year ( Get ( CurrentDate ) ) ); "First"; If (Get ( CurrentDate ) ≥ Date ( 1 ; 1 ; Year ( Get ( CurrentDate ) )) and Get ( CurrentDate ) ≤ Date ( 6 ; 30 ; Year ( Get ( CurrentDate ) ) ); "Second";""))

 

I woud think that every record would show the value "First", since the current date on my computer ils 8/28/2011.  However, most records show "Second".

 

Am I using this Get (CurrentDate) field incorrectly?

 

Angie

Outcomes