Dataset display filter

I’m trying to get my dataset to filter itself out for days that have already passed. I tried NOW() > sDate but it will still show days that have already passed. I have added how my dataset is setup

  1. sDate formated as 04/1/2017
  2. sTime formated as 10:00p.m.
  3. sDescription formated as text field

It has event data for the next two months and I want filter out events that have already passed. What would I need to do to get this to work. Thanks in advance for any help that can be given.

NOW() will return something in the format YYYY-MM-DD HH:MM:SS, so comparing 04/1/2017 to it isn’t going to work.

You’d need to either format sDate in the above format, or get MySQL to convert the date format from sDate to YYYY-MM-DD HH:MM:SS for you.

Something like NOW() < STR_TO_DATE(sDate, '%d/%m/%Y') might work for you.

Thanks, that help me big time got it working now

I just took the csv file that our registration program makes made a new column and copied the date to it formatted it yyyy-mm-dd added a new column in the dataset name sHidden. Did NOW() < sHidden and now its filtering.

Thanks again for your help. Didn’t know the date had to be formated a certain way.

1 Like