how to count dates?

[#1]

Thanks in advance to answer this simple question.

I have a list  of duties and dates. A worker can do several jobs in the same date. I need to count how many days has he/she been working, taking in considetarion that 3 jobs in 05/12/2011 is only 1.

How to do count 1 day if in the list I have 3 times the 05/12/2011??

Thanks in advance

[#2]

try Count(Distinct date)

[#3]

Thanks but it doesn't work.  I have put    COUNT( [DISTINCT] TPE_FEC) without  "," or something else but it doesn't work.  The format of the date is YYYY-MM-DD  HH:MM:SS . Could be this  the problem??

[#4 · Accepted solution]

that could be. does this work?

Count(Distinct date(TPE_FEC))

[#5]

IT WORKS ¡¡¡   thanks very much.