1 Reply Latest reply on Feb 21, 2013 5:06 AM by jholebrook

    Date query in Crystal formula

    Rookie

      I am trying to write a formula to give me a list of Incidents logged up to the current date since December 2012 but am struggling with the date.

       

      This is basically worded:-

       

      // if {creation date} is greater than or equal to {December 2012} then
      //       formula = "Y"
      //  else
      //       formula = "N"

       

       

       

      And this is my formula so far:-

       

      if {pm_process.pm_creation_date} = {??} then
          formula = "Y"
      else
          formula = "N"
      end if

       

      Can anyone help me the date part of the formula?