Hepl - Year and Month functions

[abc567]

Hi,
I have a date field and i want to display it as
200101
200102
...

I used ToText(Year(datefield)) &ToText(Month(Datefield))
and i am getting
2,0011
2,0012
....


Thanks ..

 

[CoSpringsGuy]

totext(year(datefield),0,"")&totext(month(datefield),0)

or if you are only doing this for viewing purposes... go to the field formating ... select custom style and manipulate your output from that screen



_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[abc567]

Thanks CoSpringsGuy..

The output is 20011, 20012..
I need 200101, 200102,....

 

[MCuthill]

IF (month(datefield)) <10 THEN
totext(year(datefield),0,"")& "0" & totext(month(datefield),0)
ELSE
totext(year(datefield),0,"")&totext(month(datefield),0)

Hope this helps!

Mike
--------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure, in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
Author R.A. Salvatore via "Drizz't"

 

[CoSpringsGuy]

totext(year(datefield),0,"")
&
replicatestring("0",len(totext(month(datefield),0))-2)
&
totext(month(datefield),0)

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[abc567]

Thank you buddy MCuthill...
Appreciate your help..

 

[abc567]

CoSpringsGuy's answer dint work..
It says " The no. of copies of string is too large or not an integer "


Any ways i got the answer thru MCuthill..

Thanks CoSpringsGuy

 

[CoSpringsGuy]

yep .. sorry about that .. I see where my solution went wrong .. was working on a fix but Im glad you got the correct response!!

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

Use:

totext(year(datefield),"0000")&totext(month(datefield),"00")

 

[abc567]

Wow..!!
Thanks lbass..
That was short and sweet...

 

[MCuthill]

I tip my hat to you lbass, always rocking the most concise solutions!

Mike
--------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure, in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
Author R.A. Salvatore via "Drizz't"