Date Calculation help

[topjobs]

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

[Josh Ormond]

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)

[topjobs]

Thank you very much B)

[mr_vodka]

Try this.

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

[mr_vodka]

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.

[Josh Ormond]

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

[comment]

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

YourDate ≤ Date ( 1 ; 1 ; 2009 )

[Josh Ormond]

Still working that one into my memory banks.

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

Thanks comment.

[Lee Smith]

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

[comment]

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