Conditional formatting

[Marco]

Hi. I'm trying here to use conditional formatting to put a record in red
every time the record date is bigger then today.

I have this on conditional formatting in expression option:

Format([Data];"short date")>Format(Now();"short date")

With that I have it almost working.

The problem is that I only can put get the one's that the day is bigger, not
the inteire date.

So, instead of one row bigger then 25-Nov-2008 I've got all days of the
month that are bigger then day 25.

How can I solve this?

Regards,
Marco

 

[Rick Brandt]

Hi. I'm trying here to use conditional formatting to put a record in red
every time the record date is bigger then today.

I have this on conditional formatting in expression option:

Format([Data];"short date")>Format(Now();"short date")

With that I have it almost working.

The problem is that I only can put get the one's that the day is bigger,
not the inteire date.

So, instead of one row bigger then 25-Nov-2008 I've got all days of the
month that are bigger then day 25.

How can I solve this?

Regards,
Marco

The Format() function returns strings. Get rid of that. Formatting
means nothing when doing DateTime comparisons. If you don't want time to
be factored in just use...

[Data] >= DateAdd("d", 1, Date())

 

[Marco]

You're the best man.

Hi. I'm trying here to use conditional formatting to put a record in red
every time the record date is bigger then today.

I have this on conditional formatting in expression option:

Format([Data];"short date")>Format(Now();"short date")

With that I have it almost working.

The problem is that I only can put get the one's that the day is bigger,
not the inteire date.

So, instead of one row bigger then 25-Nov-2008 I've got all days of the
month that are bigger then day 25.

How can I solve this?

Regards,
Marco

The Format() function returns strings. Get rid of that. Formatting
means nothing when doing DateTime comparisons. If you don't want time to
be factored in just use...

[Data] >= DateAdd("d", 1, Date())