String to Date

Post Author: D moore

CA Forum: Formula

I am having problems converting a string to a date. The string is in the format 2/29/2004 11:00.

I have tried cdate({table.field}) but it keeps saying Bad Date Format. its a bit unusual because if i test this field by isdate, it comes back as true so i should be able to convert it.

I want to use this in parameters also. Basically i want to get a records between this date.

has anyone any ideas? there must be some different function i should be using ?

Thanks.