Apply filter in Confiform Datetime Interval

Junard_Paolo January 29, 2020

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.

1 answer

0 votes
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 30, 2020

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)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events