change yyyy/mm/dd to mm/dd/yyyy

[cbum]

I have a FM7 database with several date fields in the yyyy/mm/dd format I need to get to standard mm/dd/yyyy format. The computer system default is mm/dd/yyyy. The file was probably originally an excel file import.

When I try by changing the date format in the layout mode (from leave as entered), the result is a ?, which reverts to the previous yyyy/mm/dd format when clicked upon.

Is there no way to change this easily, short of a complex multistep find and replace operation?

[comment]

See if this thread helps:

http://www.fmforums.com/threads/showflat...true#Post156556

[cbum]

Thanks for your uhm, comment ;-)

your calc works fine, I was hoping for more built in date intelligence.