Link to home
Start Free TrialLog in
Avatar of Anil Lad
Anil LadFlag for Canada

asked on

How to get French date in Crystal report

I have crytal report 8.5  
Currently I am generating a report that shows date as dd-mmm-yyyy format.
How do I change the date show that mmm will show in french instead of french?

Thanks.
Al
Avatar of Mike McCracken
Mike McCracken

Do you have the French version of Crystal?

Are you trying to do this in Crystal?

mlmcc
Avatar of Anil Lad

ASKER

No just english version of crystal
Yes I am trying to do this in crystal.
Thanks
Al
Unless I am mistaken you need the French version to display it in French.

With that being said you can use a formula to do what you desire

Something like

If (Month({MyDateField}) = 1) then
  toText(Day({MyDateField})) & " Jan " &   toText(Year({MyDateField}))
ElseIf (Month({MyDateField}) = 2) then
  toText(Day({MyDateField})) & " Fev " &   toText(Year({MyDateField}))
ElseIf (Month({MyDateField}) = 3) then
  toText(Day({MyDateField})) & " Mar " &   toText(Year({MyDateField}))
ElseIf (Month({MyDateField}) = 2) then
  toText(Day({MyDateField})) & " Avr " &   toText(Year({MyDateField}))
etc

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of KENNETH TURNER
KENNETH TURNER

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have further problem with the crystal report.
This is proably too easy for you guys, but
My date is giving me decimal 00s.
This is what I did to convert my english to date to french as follows:
I created a formula field.  
When I this text is displayed it's coming out as  for example 1.00-Fev-2,004.00

How do I get rid off .00?  and that comma in the year is also bother some.

Day ({V_AUTOREN.RENEWAL_DATE})
&
'-' &
mid('JanFevMarAvrMaiJunJuiAouSepOctNovDec', 1 + ((Month({V_AUTOREN.RENEWAL_DATE}) - 1) * 3), 3 )
&
'-' &
Year ({V_AUTOREN.RENEWAL_DATE})
Try this.

ToText(Day ({V_AUTOREN.RENEWAL_DATE}),0)
&
'-' &
mid('JanFevMarAvrMaiJunJuiAouSepOctNovDec', 1 + ((Month({V_AUTOREN.RENEWAL_DATE}) - 1) * 3), 3 )
&
'-' &
ToText(Year ({V_AUTOREN.RENEWAL_DATE}),0)

mlmcc

Thank you mlmcc.  the .00 are gone now.
thx