Need help with a Date $where statement

2 posts by 2 authors in: Forums > CMS Builder
Last Post: December 31, 2018   (RSS)

By nmsinc - December 30, 2018

I need a '$where' statement.

I need it to list only records where the year in the date record is greater than 2017!

Thanks - nmsinc

nmsinc

By daniel - December 31, 2018

Hi nmsinc,

A simple way to do this is to look for dates greater than or equal to January 1, 2018, like this:

createdDate >= '2018-01-01 00:00:00'

Let me know any questions!

Thanks,

Daniel
Technical Lead
interactivetools.com