Anil Lad
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
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
ASKER
No just english version of crystal
Yes I am trying to do this in crystal.
Thanks
Al
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
With that being said you can use a formula to do what you desire
Something like
If (Month({MyDateField}) = 1) then
toText(Day({MyDateField}))
ElseIf (Month({MyDateField}) = 2) then
toText(Day({MyDateField}))
ElseIf (Month({MyDateField}) = 3) then
toText(Day({MyDateField}))
ElseIf (Month({MyDateField}) = 2) then
toText(Day({MyDateField}))
etc
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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('JanFevMarAvrMaiJunJui AouSepOctN ovDec', 1 + ((Month({V_AUTOREN.RENEWAL _DATE}) - 1) * 3), 3 )
&
'-' &
Year ({V_AUTOREN.RENEWAL_DATE})
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('JanFevMarAvrMaiJunJui
&
'-' &
Year ({V_AUTOREN.RENEWAL_DATE})
Try this.
ToText(Day ({V_AUTOREN.RENEWAL_DATE}) ,0)
&
'-' &
mid('JanFevMarAvrMaiJunJui AouSepOctN ovDec', 1 + ((Month({V_AUTOREN.RENEWAL _DATE}) - 1) * 3), 3 )
&
'-' &
ToText(Year ({V_AUTOREN.RENEWAL_DATE}) ,0)
mlmcc
ToText(Day ({V_AUTOREN.RENEWAL_DATE})
&
'-' &
mid('JanFevMarAvrMaiJunJui
&
'-' &
ToText(Year ({V_AUTOREN.RENEWAL_DATE})
mlmcc
ASKER
Thank you mlmcc. the .00 are gone now.
thx
thx
Are you trying to do this in Crystal?
mlmcc