Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Try this:
Date(Floor([Checked]))&' , '&[CheckedBy] as Key,
Floor(timestampfield) or Date(timestampfield,'YourDateFormat')