Where setting in App builder
-
‘Event Date’ >= ‘date_sub(now(), interval 1 week)’
Event Date is an alias for start_date in my original function (created in Code Manager) that creates this table.
Every combination I tried (except the above which returned the full table with a count of 1-0) returns an empty table.
I have tried ‘Event Date’ >= date_sub(now(), interval 1 week), Event Date >= date_sub(now(), interval 1 week), ‘Event Date’ >= date_sub(now(), interval 6 day), all return empty table…
What am I doing wrong? BTW, order by Event Date Desc works fine. It would be nice to have a similar drop down in the Where box to be able to choose columns.
The page I need help with: [log in to see the link]
- You must be logged in to reply to this topic.