concatenate a date field
Posted on 2012-03-28
Hi, I'm making a crystal report and used a parameter: date, "10/23/2010". I'd like to create a single numeric field from a formula like "201010". When I create the date "10/23/2010" as Year 2010 (number) then Month 10 (number) then try to concatenate the two I get a string value with comma and decimal like 2,010.00 then I can not format the field, same for the month 10.00 they both show up as string values.
Is there a way to do this as 201010? I need to do some calculation and compare on these fields once created as formulat. What do I need to use? I tried Concatenate (&, +""+,Var,Cstr,etc.) Is there anyway to do this? Thanks in advance.