Is it possible to apply filter in Confiform Datetime Interval? Say display list of upcoming events for the next 7 days? I can do it using Date and Datetime field but I tried in Datetime Interval but it is not working. I am not sure if its feasible. Thank you.
DateTime interval has 2 dates for start and end. See more on https://wiki.vertuna.com/display/CONFIFORMS/Accessing+field+values+and+properties
Depending on what you want to filter on you can do something like
myDateTimeField.startDate:>=([entry._now]) AND myDateTimeField.startDate:<=([entry._now]+604800000)
where
604800000 = 7 (days) * 86400000 (milliseconds per day)
Alternatively the filter can use [today] shortcut and so something like
myDateTimeField.startDate:>=([entry._now]) AND myDateTimeField.startDate:<=([today]+7)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.