Filter records by date

We have been asked if it is possible to set the Layer’s Filter Query in Earthlight in such way as to have records with past date hidden from view.

It has taken some time to investigate this matter and find and structure the SQL query but we did it. Provided that you have a DateTime type field in your table, you can set this up quite easily using this SQL query:

[COLUMN_NAME] >= CAST(GETDATE() AS DATE)
where:
[COLUMN_NAME] is the name of the DateTime type field

E.g.:

Please note:
This query was tested in SQL Server so if you have other type of spatial database (PostgreSQL or Oracle) you may need to amend it.