Remove slashes and decimals from concatenated field 1

[jkupov]

Hello,

I have to pass a field in a report which is a combination of the service ID and Service date. I know that I can remove the slashes from the date field and the decimals from the number field via formatting, but I need to concatenate the fields so that 08/07/2012 1234 becomes 123408072012.

I used totext({DateField),"ddmmyyyy", but instead of 08072012 I got 06002012 , which is not at all what i expected.

When concatenating them {ServiceID}&totext({ServiceDate},"ddmmyyyy")

I get 1,234.0006002012

I want to remove the comma and decimal from the ServiceID and the slashes from the ServiceDate.

 

[jkupov]

I should point out my error in my original post. I want 08/06/12 to be 08062012 but I used "ddmmyyyy" instead of "mmddyyyy". That said, the month field is still showing up as 00 instead of 08. 'mm' is what I want to use right? No matter which month I query it shows the month as 00 instead of the numerical value of the month.

 

[CoSpringsGuy]

totext({ServiceID},"#") & " "& totext({ServiceDate}),"ddMMyyyy")

or
totext({ServiceID},"#") & " "& totext(date({ServiceDate}),"ddMMyyyy")

_____________________________________
Crystal Reports 2008 and XI
Intersystems Cache 2012 ODBC connection

 

[jkupov]

Good- thsank you.