Date Formatting

[Zeuromus]

How do I get the date to be formatted MM-DD-YYYY instead of YYYY-MM-DD. The program we are reporting from wants to format the date in YYYY-MM-DD, which is really annoying. Is there a UFL out there to format the date differently??

:-9

 

[akinia]

Hi Zeuromus !

Do you have tried to change the format of the date in the menu FILE - Option and Date in the Field-Tab.
I've The version 6 of CR and it works quite good.

Akinia

 

[kridg]

I have the same problem with a database that stores the date as a string, and then in the format of YYYY-MM-DD. I use this formula to reformat it (still as a string, date calcs won't work) but puts it into MM-DD-YYYY.

({Query.ActionDate}[6 to 7] + "-" + {Query.ActionDate}[9 to 10]+ "-" +
{Query.ActionDate}[1 to 4])

 

[MalcolmW]

Also check out the FAQ for Common Formulas

http://www.tek-tips.com/faqs.cfm?spid=149&sfid=243&CFID=8028880&CFTOKEN=46333820

Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?