Searching dates

edited November 2012 in End User
I have created two calculated fields: Date(Today(*)-2) and
Date(DateTimeOccurred). I would like to use them in the SEARCH
Date(DateTimeOccurred) = Date(Today(*)-2; but if I type the expression
Date(Today(*)-2) I get Invalid SQL statement. Doesn't appear that I can
use the calculated field either. It gives the same result. Any ideas?

Thank you
v12.03 Build 348

--- posted by geoForum on


  • edited December 2012
    Hi Greg,

    It is not possible to compare two calculated fields as a search
    condition, but it is possible to compare a calculated field to an
    expression. For instance, you could add the calculated field :
    Date(DateTimeOccured) then add that field as a search condition and have
    the "Date(Today(*) - 2" as the value (assuming your DB supports this

    Best Regards,

    Nico Cizik
    Digital Metaphors
This discussion has been closed.