Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
it doesn't work