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
What's the script used to create the key?
[Checked]&' , '&[CheckedBy] as Key,
Date(Floor([Checked]))&' , '&[CheckedBy] as Key,
Floor(timestampfield) or Date(timestampfield,'YourDateFormat')
Retrieving data ...