concatenate

[ram]

Hi I would like to ask for help on the following:

I would like to concatenate datevalue([Process_Date]) & [Employee_Number]

When I use the formula above the datevalue function gives me the date
serial number for the process_date however it won't allow me to concatenate
with the general number that is used in the employee_Number field.


I would like to concatenate the serial number of the process_date with the
employee_number

Thanks in advance for any help

 

[Laura Cook]

Not sure of exactly how you want it formated, but this should get you headed
in the right direction:

=CONCATENATE(TEXT(process_date,"mm/dd/yyyy"),employee_number)