4 Replies Latest reply: Sep 28, 2018 5:32 AM by Tim Poismans RSS

    Count Accounts using Today

    Steve Littlewood

      Hi,

       

      I need a calculate field 'New accounts this month' to have a calculations as follows:

       

      if M_Date (formatted YYYY-MM-DD) = current month then 1 else 0

       

      Any idea how to write the syntax for this please?