Amend Symbol & With Date Formats

[KuraiChikara]

Is it possible to use the amend symbol (&) with a date and keep the date format?
The purpose would be to create a unique identifier for Vlookups but the result is not user friendly.

Example:
A user could show up multiple times, their duties could show up multiple times, the only thing that would differentiate it would be the date.

If I wanted to create a unique value to perform a VLOOKUP, I would do the following with the pipe symbol (|) to separate the values but I don't like the end result of the date:

Putting in this formula: =A2&"|"&B2&"|"&C2
Yields this result: John|Lawn|43578

Is it possible to get the date shown as a date? My end goal would be this John|Lawn|04/23/2019

Unique Value Formula	Name	Duty	Date
John|Lawn|43578	John	Lawn	04/23/2019
John|Lawn|43577	John	Lawn	04/22/2019

<tbody>
</tbody>

 

[Scott T]

=A2&"|"&B2&"|"&TEXT(C2,"mm/dd/yyyy")

Note that even though it looks like a date it is actually text.

 

[KuraiChikara]

This works for what I need, thank you very much!