Explain Date Calculation Inconsistancies

[Tyra]

Can some explain to me why the Calculation below works for most date ranges, but not all, like the two date ranges below.

[unstored,from Company,= Case

( Get ( CurrentDate)≥ s_Contract_Start

and

Get ( CurrentDate )≤ s_Contract_End;

"YES";"NO")]

Shows "NO" if:

s_Contract_Start= 4/5/2008

s_Contract_End= 4/4/2011

and

s_Contract_Start= 6/26/2008

s_Contract_End= 6/30/2009

Both should show "YES".

[comment]

Could you post a simple file showing the problem?

[Tyra]

Comment, thank you for your help!! As I started to create a quick file to show the issue, I realized that I had marked "s_Contract_Start" as a Text field instead of a date field. Although weird why it was working for most ranges, definitely works correctly now.

Probably would help to get more then 2-4 hours of sleep each night.