Creating a KEY with datetime stamp and date

[#1]

I created a Key to link the two sets of data but the second key is a date time stamp.

I need to convert it to just a date

need to remove time part of it

[sunny_talwar]

What's the script used to create the key?

[#3]

[Checked]&' , '&[CheckedBy] as Key,

[sunny_talwar · Accepted solution]

Try this:

Date(Floor([Checked]))&' , '&[CheckedBy] as Key,

[vinieme12]

Floor(timestampfield) or Date(timestampfield,'YourDateFormat')