3 Replies Latest reply on Aug 23, 2013 11:28 AM by Shawn Wallwork

    how to refer to date in calculated field?

    caroline ennis

      I am trying to create a calculated field that pulls MAX [HIRE_DATE] >= 10/31/2012. No matter what combination of date formatting or field references I use it says I cannot compare a string and a date. Can anyone advise what I may be doing wrong? HIRE_DATE is a date format and I've tried various ways to reference 10/31/2012 -- 31-Oct-2012, 2013-10-31, etc. Can anyone advise?