Error in Formula regarding data formats

[jfokas]

I get an an error when running the following formula:

IF CURRENTDATE - 30 < DATE({QUERY.AgingDate}) THEN 1 ELSE 0

The AgingDate field is a string field with the following format: 2004/04/15 13:42:00.00

The error I get states the following:

Error: Bad date format string
--{QUERY.AgingDate}: "2004/04/15 13:42:00.00"
--CurrentDate - 30: #2004-4-17#

I've tried manipulating the format several different ways, to no avail. Can an anyone tell me what we're misssing?

Thanks!

 

[kskid]

Since the date is a string field, have you tried using CDate?

CDate({QUERY.AgingDate}) instead of DATE({QUERY.AgingDate})

 

[lbass]

Try the following:

if currentdate - 30 < date(val(left({table.stringdate},4)),val(mid({table.stringdate},6,2)),val(mid({table.stringdate},9,2))) then 1 else 0

-LB