Date problem

[Seabz420]

I have a date in my data that's formatted like 8/12/2004. Crystal is displaying as Dec 8, 2004 instead of Aug 12, 2004. I need Crystal to see that data like mm/dd/yyyy not dd/mm/yyyy. This is the only report I have that does this and my system is setup to read as mm/dd/yyyy. Ideas? I'm using CR 10 w/ windows xp.

 

[Seabz420]

One other thing, this isn't a problem when running this report on another windows xp machine using CR 10.

 

[synapsevampire]

Right click the field in Crystal and select format field and give it an explicit format (it's probably currently using the system default).

-k

 

[Seabz420]

When I right click and choose format, I change the way the dates displays but not the way the date is interpreted. Yes, the setting is coming from my system. Do I need to code something to that field?

 

[synapsevampire]

That's Euro format.

Are you sure that you understand the date correctly?

If you're positive, you'll need to reformat the date.

cdate(year({table.date},day({table.date},month({table.date})

-k

 

[synapsevampire]

Ooops, forgot some parens:

cdate(year({table.date}),day({table.date}),month({table.date}))

 

[Seabz420]

I did eventually change date on my system and this corrects the problem with the report, but now I am keeping a close watch to see if any other date issues crop up! Thanks for your help!

 

[synapsevampire]

Yep, euro settings, that'll do it.

-k