Advanced Filtering - "Greater Than" Date

Follow

Craig

• October 31, 2017 19:39

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

 

 

0

• 

  Alan

  • October 31, 2017 20:27

  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

  • November 01, 2017 21:35

  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.