Formating Date

[Frank336]

(VB6, CR8.5(RDC), Access 2000)

Hi,

ive got a problem with date formating. First of all, I must say that Im using french regional parameters and crystal syntax.

When i use the following formula in a UnboundString :

cstr(DatePart("YYYY", currentDate),0)

the year is print : 2 002 and not 2002

So Ive try using :

replace(cstr(DatePart("YYYY", currentDate),0), " ", "&quot

but the result is the same... 2 002

With US regional parameter the "Replace" remove the "," in "2,002"

What is wrong with my formula ? Maybe I could try Basic Syntax but im not sure how its working in Formulas...


Thanks,
Frank

 

[dgillz]

totext(datepart("yyyy",Currentdate),0,"&quot works for me. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[chelseatech]

You could also use
ToText(CurrentDate,"yyyy&quot

ToText formats dates as well as numbers. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Frank336]

Thank you !