assuming your table fields are text you can use a formula to convert it to a date by using left and mid functions

Edited by DBlank - 03 Apr 2014 at 4:22am

Well, I was wrong on my initial post.

The table date is in a DATE format of YYYY-MM-DD.

It must be converted to text, re-arranged, the dashes have to go, and then converted back to a CR date field (MM/DD/YYYY format).

So, I created this monstrosity of a formula:

Date (mid(totext({INV.INV_DATE_O}),6,2)+'/'
      +right(totext({INV.INV_DATE_O}),2)+'/'
      +left(totext({INV.INV_DATE_O}),4))

It comes back with "No Errors", but when I try to update the report data, an error of "Bad Date Format String" happens. What could I be missing?

Edited by hello - 03 Apr 2014 at 6:30am

I did this, and to my surprise...

When I drag the table date field to the canvas (even without ToText), it displays as MM/DD/YYYY!

But, doing an SQL query, the result screen shows the same date field as YYYY-MM-DD.

I guess CR is automatically converting it somehow???

I must have a problem with a different part of my formula other than comparing dates.

Thanks for the help DBlank.