Count when a word is repeated more than once in a day as one

[matbelli]

Hi all, i need to count multiple items in one day as one, i have a table like this:

IdConto

NumConto

Data

CampiModificati

10268341	268324069489	19/07/2018 17:49:07	documento
10268341	268324069489	19/07/2018 17:50:26	cap
10268341	268324069489	23/07/2018 10:44:01	id_tipo_documento
10268341	268324069489	23/07/2018 10:45:16	documento
10268341	268324069489	23/07/2018 10:45:17	documento
10264325	268324069489	23/07/2018 10:45:18	documento
10268341	268324069489	23/07/2018 10:45:19	documento
10268341	268324069489	23/07/2018 10:45:19	documento

I need to count everytime i find "documento" or "id_tipo_documento"and it has to count  2, one for 19/07 and one for 23/07 for IdConto 10268341. How can i do it?

Thanks in advance

[uacg0009]

Hi Matbelli,
Do you mean you need to :
Count(distinct {<CampiModificati = {"documento","id_tipo_documento"}>}Date(Data,'YYYY-MM-DD'))
Please try.
if your "Data" column is not "Date" type, you can use left() function in it.
Aiolos Zhao

[matbelli]

it doesn't work 

[uacg0009]

in my desktop it worked.
if you don't share a sample, we don't know why it doesn't work
and you even don't say what the result is after you did