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
- sDate formated as 04/1/2017
- sTime formated as 10:00p.m.
- 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
YYYY-MM-DD HH:MM:SS for you.
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.