.[DateColumn] = ? Input_date ?
or for a date range filter (requiring two date filters, thus two input parameters):
.[DateColumn] >= ? Input_date_1 ? AND .[DateColumn] <= ? Input_date_2 ?
---
If you absolutely need it done in FM, then you need to clarify a bit.
[relational_db].[QUERY_SUBJECT_NAME].[MY_KEY] > '20201028' would yield fields starting from the date '20201029', and the filter:
[relational_db].[QUERY_SUBJECT_NAME].[MY_KEY] > year(current_date) || month(current_date) || day(current_date) searches for rows having a day "larger" than today. If you need rows exactly for today, you either need to use the inclusive operator >= or simply =
In your test table with 2k rows, what date rows did it select for you, and which date did you filter for? |
|
|