You are viewing limited content. For full access, please sign in.

Question

Question

concatenate with a date

Forms
Updated June 1, 2021
asked on June 1, 2021

I would like to concatenate fields that have dates

For instance Concatenate the Employee Name then Date Hired to show:

=CONCATENATE(EMPFIRST, " ",EMPLAST," DATE HIRED: ",HIREDATE)

First Last; DATE HIRED: 01/01/2021  The date ends up just a series of numbers.

0 0

Answer

SELECTED ANSWER
replied on June 1, 2021

You can grab the month, day and year of that date field independently. 

=CONCATENATE(First," ",Last," Date Hired: ",MONTH(Date_Hired),"/",DAY(Date_Hired),"/",YEAR(Date_Hired))

You can also wrap it in an if statement so that it stays blank until the hire date is filled out. Otherwise it could show an error before the date is filled in.

=IF(Date_Hired="","",CONCATENATE(First," ",Last," Date Hired: ",MONTH(Date_Hired),"/",DAY(Date_Hired),"/",YEAR(Date_Hired)))

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...