simple count function

[bhavvibudagam]

Hi Experts,

Can any one please help me on this.

Under DOB field I have entries like

DOB

1991-05-12

2002-01-29

1985-06-30

2011/19/01

02/05/2015

I have to count the DOB where is not in the YYYY-MM-DD format.

Example

2011/19/01

02/05/2015 is in different format so the count is 2.

Thanks in advance.

[Anil_Babu_Samineni · Accepted solution]

May be create flag like?

If(Date(DOB, 'YYYY-MM-DD'), 1,0) as Flag

And expression is

Count({<Flag = {0}>} Date)

[sunny_talwar]

May be this

If(IsNum(Num(Date#(DOB, 'YYYY/DD/MM'))), 1,

If(IsNum(Num(Date#(DOB, 'DD/MM/YYYY'))), 2)) as DOBFormatFlag

and then just do Count(DISTINCT DOBFormatFlag)