Advanced Filtering - "Greater Than" Date

2 followers
0
Avatar

Hello,

I am completely new to Datameer. I am trying to set up an advanced filter on a Date column. How do I simply create an advanced filter that correctly filters as such, #DateColumn >= 07/01/2017   ?

I've tried multiple versions of the date: 20170701 , 07-01-2017, etc.

Thanks

 

 

Craig

2 comments

  • Avatar
    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
Please sign in to leave a comment.