concatenate

R

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
 
L

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top