language specific date format

[berny]

Hi,

I need to put the same dates (from a field) on two reports - one report is in English, one is in German. The English format should be "December 24, 2006", the German format should be "24. Dezember 2006". Any ideas how to solve that?

Thank you

Berny

[IdealData]

You can specify the date format for each instance of the date field. Use specify date format.

[berny]

The problem is that the format has to be language specific - try to set a date instance to German format, not possible when you are running the application on English settings.

Cheers

Berny

[berny]

I am sure there are smarter solutions to that - but here is what I did as an interim:

I added an additional calculation filed with result as text - this calculation translates the German format into English format:

dateAsTextE=

Case

(MonthName (dateField)="Jänner";"January "&Day(dateField)&”, ”&Year(dateField);

MonthName (dateField)="Februar";"February "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="März";"March "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="April";"April "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="Mai";"May "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="Juni";"June "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="Juli";"July "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="August";" August "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="September";"September "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="Oktober";"October "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="November";"November "&Day(dateField)&”, “&Year(dateField);

MonthName (dateField)="Dezember";"December "&Day(dateField)&”, “&Year(dateField);

"")

[comment]

How about:

Choose ( Month ( dateField ) - 1 ; "January " ; "February " ; "March " ; "April " ; "May " ; "June " ; "July " ; "August " ; "September " ; "October " ; "November " ; "December " )

&

Day ( dateField ) &”, “ & Year ( dateField )

This will also work if the file is in French or any other langauge.

Edited July 14, 2006 by Guest
Fixed a blaring omission (thanks, LaRetta!)