Conditional Formatting on timestamp

[jonep]

We have a customer name field that is coloured red.

We also have a creation timestamp field.

We would like to be able to have conditional formatting set up so that if creation is before 10/07/2011 it displays as red if after it is blue.

The timestamps appear in our layout in this format: "21/02/2011 10:11:36"

I therefore assumed something like

Table::CreationTimestamp ≥ "10/07/2011 10:11:36"

Would do the job. That though just makes alerts from on or before the 10th of each month blue.

How should I be going about this? I am aware that the timestamp is effectively a converted number, is there some way to do it using this number? Or is there some obvious method I am missing?

Thanks

[comment]

Try =

GetasDate ( Table::CreationTimestamp ) < Date ( 7 ; 10 ; 2011 )

(I am assuming "10/07/2011" means July 10).

What is so special about this date that you want to hardcode it?

[jonep]

Basically we are changing the way one of our packages works and we want and obvious way to see which companies came in before or after that date.

Thanks that worked great.