Fetch only Date

[help4qv123]

Hi,

'I have a database in which one of the column has dates and some duplicate values or records in it. i need to show only count(date).

plz check the  attachmnt

[prajapatiamar38]

Hi....

Please find the attachment.

I have used Flag it is coming right now.

[maxgro]

count(if(isnum(date#(date, 'DD-MMM-YYYY')), distinct date))

[help4qv123]

yes , but how can we create a flag?