How to filter records by date range using "created" metadata field in Confiforms TableView

Question

I would like a TableView to filter records by a specific date range based on the "created" metadata field.

Initially, I had users submit a date, and filtered for entries based on this field. Example: I used "date:<[date20240102] AND date:>[date20231212]" to only display entries where the user selected a date between December 12, 2023 - January 2, 2024.

I want to omit having users submit a specific date (and delete the "date" field), and perform the same function based on the metadata field "created".

Can someone help me with what I should use in the "filter to apply on entries dataset" to accomplish this?

Anne Luckey · Answer

EDIT: Figured it out! Nevermind.

One additional question, I submitted an entry in my form this morning and it did not show in a tableview with this filter: created:>[date20240222 06:00] AND created<[date20240305 05:59].

Can you help me identify why it would not show in this tableview? I have used the same tableview filtered by different dates that have shown records before. For reference, I am in CST.

Alex Medved _ConfiForms_ · Answer

Of course you can

You can access current date from the context https://wiki.vertuna.com/display/CONFIFORMS/Accessing+field+values+and+properties#Accessingfieldvaluesandproperties-Additionalvaluesavailableinthecontext

and use that in a filtering expression

somedate:>[entry._now]

(somedate is after today/now)

Alex

Miles Smith_m61oma · Answer

I'm thinking - is there a way to filter records in a tableview by the current date (so a table only shows records, such as milestones, that exist before or after the current date).

Please let me know if you have any ideas?