Thanks, brsamuel, but I tried it and I'm not sure that's what I'm looking for. This seems to return only the unique values from a list in a field in a single record.
To be clear, in my scenario there is only one value per field per record, but many records may have the same value in that field. In other words, each record has a single value in the "Uploaded On" field, but multiple files may have been uploaded on the same day so multiple records may have the same value in the "Uploaded On" field.
What I'm looking for is list of those singular values summarized in one, global field.
If two files wer uploaded on Monday, one on Tuesday and three on Thursday, I want one, glopal field that says: Monday, Tuesday, Thursday much as I can have a global summary field that says "6 total files were uploaded."
Does this make more sense?
Execute Sql ( "Select COUNT(Distinct datevalue from Table) ",";"cr") for the count
Execute Sql ( "Select Distinct datevalue from Table ",";"cr" ) for the list of dates
PS make sure the field is not called Date or Day .. SQL is picky