3 Replies Latest reply: Nov 5, 2014 4:29 AM by Ashfaq Mohammed RSS

    Counting Dateformats

      Hi all,

       

      I have a question I hope someone would be able to help me with. I have a column which displays date in varying formats: some are 'DDMMYYYY', some are 'MMDDYYY', some 'YYYYMMDD' and so on and so forth. Is there perhaps a command that would count all the distinct date formats and then report a count for each? I suppose something along the lines of Count(if(.....) as expression and Count distinct as dimensions in a chart, but I can't figure out a precise format.

       

      Thank you all so much!