Recent content by crash58

I am working on a report (v 8.5, SQL DB) that involves bibliographic citations in a subreport. The citation formula is comprised of multiple individual formulas, and thanks to lots of posts here, I found out how to format the text of those using html tags and turning on the paragraph text...

totext(date({Exhibitions.BeginISODate}),"MMMM d, yyyy") returns "Bad Date Format String" when run in report. Hear that crash? It's my head... thank you for your help - if you have any other ideas, I'm wide open.

When I do date OR cdate({mytable.field}) the formula editor accepts it, I place the formula in the report and when I run the report I get "Bad date format string" An isdate ({mytable.field}) returns true. However if I place the field in the report and right click on the field in the...

Hello - I have spent the afternoon reading posts about similar problems and none of the solutions have worked so far. I am using CR8.5 and an SQL database; the data is in 10 character varchar YYYY-MM-DD. I want a formula or a series of formulas to make this display as March 1, 1999. thanks in...

The field is a string field to which I've applied the cdate function. totext(CDate({Exhibitions.BeginISODate}))+" - "+totext(cdate({Exhibitions.EndISODate})) How can I format the date from within the formula? Thank you for your help!

I am attempting to format a date as Wednesday, March 1, 2003 rather than March 01. When I select all the obvious boxes, the example changes, but then when I get out to the main window, the custom format is not reflected, and of course it does not display in the report. I must have some sort of...