I would like to have a field that shows 1 if the date field is at or prior to 1/1/09 and 0 if the date is after 1/1/09.

Thank you

Case (Date < "1/1/2009"; 1; Date > "1/1/2009"; 0)

Assuming you don't want 1/1/2009 included.

If you want 1/1/2009 to calculate as 0:

Case (Date < "1/1/2009"; 1; Date ≥ "1/1/2009"; 0)

If you want 1/1/2009 to calculate as 1:

Case (Date ≤ "1/1/2009"; 1; Date > "1/1/2009"; 0)

Thank you very much B)

Try this.

YourDate ≤ GetAsDate ( "1/1/09" )

Case (Date < "1/1/2009"; 1; Date > "1/1/2009"; 0)

Assuming you don't want 1/1/2009 included.

If you want 1/1/2009 to calculate as 0:

Case (Date < "1/1/2009"; 1; Date ≥ "1/1/2009"; 0)

If you want 1/1/2009 to calculate as 1:

Case (Date ≤ "1/1/2009"; 1; Date > "1/1/2009"; 0)

This wont work.

Thanks John. I always use the GetAsDate() function, but always forget to include it in my replies.

I NEVER use the GetAsDate() function to specify a date, because it relies on the local date format:

YourDate ≤ Date ( 1 ; 1 ; 2009 )

Still working that one into my memory banks.

That's the problem with self-taught strategies. Bad habits.

Thanks comment.

What do you want to happen on January 1, 2010 with this flag?

That's a good question, one that I forgot to ask.