Advanced Filtering - "Greater Than" Date

Comments

2 comments

  • Alan Mark

    Hi Craig,

    Please see our documentation: 

    Working With Date and Time Information - Example of Date/Time constant within a filter

    0
    Comment actions Permalink
  • Craig

    For anyone who is looking for a solution to the question I asked, please see below:

    I was trying to use the following (which is wrong!!!):   #DateColumn >= 07/01/2017

    The correct format is:    #DateColumn >= ASDATE("07-01-2017";"MM-dd-yyyy")

     

    I was completely unaware that a date must be called out by ASDATE and then defined in order to be compared in the data.

     

    1
    Comment actions Permalink

Please sign in to leave a comment.