Date Field to be Displayed in French

[duthiedon]

We have a need to display a date field which is stored in English, to be displayed in long date format but in French. It's only necessary for the report, so I don't want to make a global change, only temporary for when the user produces the report. I have done some research, but all I can find is changing the global session.lcid (to 3084 for Canadian French). Actually have to display the field bilingual, but I can take care of displaying it in English, just not sure how to automatically display in French. Can anyone help?

Don

 

[Dennisk]

You can use the FORMAT() function to alter the format of date, numbers tec

 

[duthiedon]

Thanks, I know I can use the format() function, but how do you make it format into a french version (i.e. long date in English would be "January 8, 2009" and in French it would be Janvier 8, 2009". That's the tricky part. I know it's based on your system language default, but I only want this to be a temporary display. Any thoughts?

 

[Dennisk]

why not create a table of Months in French and give each row the default Month Number (1 - 12). Then create a function that return the French version of the month based on the month number (obtailed from the Month() function.)

 

[Ron_dK]

You might change your windows settings :
settings > configuration > country. Set both the standard and location to French-Canada and dates in Access will be in the french language.

Hth

 

[gemma-the-husky]

but if its just normally required in english, but in one instance required in french, then i think dennis's solution is the way to go.

if you use days of week, you will need a translation for these as well.

 

[duthiedon]

Thanks everyone, I ended up creating a function, was just hoping that there was an easier way. We're unique in Canada I guess, we have 2 official languages.

 

[gemma-the-husky]

tell 'em to learn english!

suivez les Anglais

 

[Ron_dK]

Thanks everyone, I ended up creating a function

It would be very interesting to see that function, could you give us an overview ?

We're unique in Canada I guess, we have 2 official languages.

Well, not exactly, What about the Belgiums, they have three official languages

 

[vdanelia]

I need this function too, can anyone help us!

 

[vbaInet]

I need this function too, can anyone help us!

vdanelia, don't double post.

 

[Brianwarnock]

Not strictly a double post , but cross reference to his other thread would avoid two people separately giving solutions

Brian

 

[vbaInet]

Not strictly a double post , but cross reference to his other thread would avoid two people separately giving solutions

Brian

http://www.access-programmers.co.uk/forums/showthread.php?t=216610