Skip to Content
0
Former Member
Sep 17, 2009 at 06:05 PM

Date format does not change with the Regional and Language Options in 2008

396 Views

I have a one-column report that was created using the SQL "select current_date" in postgres. (Thinks select getdate() ).

In Crystal Reports XI when I change the "Standards and Formats" of Regional Options to:

English (United States) the date is in the format mm/dd/yy

English (Canada) the date is in the format dd/mm/yy

Japan the date is in the format yyyy/mm/dd

In Crystal Reports 2008 when I change the "Standards and Formats" of Regional Options to:

English (United States) the date is in the format mm/dd/yy

English (Canada) the date is in the format mm/dd/yy

Japan the date is in the format mm/dd/yy

It doesn't change. Is this a bug?

Thanks in advance,

J