Date Field Formula

[mikew777]

Hi I am trying to create a formula that will only select records with a date greater than 01/01/2005.

The date is held in the field (test.opn_dt)in the format dd/mm/yyyy hh:mm:ss

However I am getting the error "A date-time is required here"

When I run the below:

if {test.grp_cd} = "TTTT" and {test.opn_dt} >= "01/01/2005 00:00:00" then "OK"

Help would be greatly appreciated

Mike

 

[Madawc]

You haven't told it that this is a date, nor given it the normal format. Try {test.opn_dt} >= Date(2005, 1, 1). Or {test.opn_dt} >= DateTime(2005, 1, 1, 0, 0) if time matters.

If that doesn't work, try displaying {test.opn_dt} on the report, to see what it actually does contain. If it is actually a string based on a date, you'll need to make it a date in order to use it. Try Cdate({test.opn_dt}) - Crystal is smart about conversions, but display the result to see what you get.

Madawc Williams (East Anglia, UK)

 

[MisterMo]

If your field is datetime type it cannot be compare with a string

try

{test.opn_dt} >= DateTime (2005,01,01,00,00,00 )

Mo

 

[mikew777]

Brilliant it was the DateTime I was missing, am still quite new to Crystal so I really appreciate the help from you both.

Thanks again
Mike