2 Replies Latest reply on Oct 1, 2012 11:36 AM by Egor Ushakov

    How to count distinct dates

    Egor Ushakov

      I have MySQL-based system which logs every user logins into separate table `loginaudit`. Since user can log into system many times a day I use to count exact dates with a simple SQL query which calculates needed value with something like  SELECT Count (DISTINCT( Date(loginaudit.date_modified) ))

      I tried to apply this approach in Formula Builder to create Calculated field but found out that there is no Date function similar to MySQL date().

      Are there any ideas how to solve an issue?

       

      P.S. It's amazing but while selecting 'All' function list you may see DATE() function . But when you switch to 'Date' list you can NOT choose the same function. It seems that 'lost' in 'All' functions list date() function works like a charm.