How to filter ConfiForms Table view to only show records from the last 14 days?

Question

Hello,

I use ConfiForms for tracking some items and each record has a "Date Created" field which is automatically set with the date of record creation.

Now I use the TableView macro to view all the data but I want to filter the records to only show me the records created in the last 14 days (2 weeks). I have been trying to figure this out but couldn't find any info in the documentation except an example which uses a specific date and not a relative date like I need.

Any help to limit the records to just the last 2 weeks would be great!

ASQS · Answer

Thank you, End Date was my missing hint.

Alex Medved _ConfiForms_ · Answer

Hi @ASQS

86400000 milliseconds in a day, so 60*86400000 = 5 184 000 000 or in days (-60) as shown in my previous comment

As for the DateTime interval, then a question to you - do you want to check the start date of the interval or the end date?

As per DTI field's properties

https://wiki.vertuna.com/display/CONFIFORMS/Accessing+field+values+and+properties

mydatetimefield.startDate:>([today]-60)

Alex

ASQS · Answer

Thanks Alex,

can you explain to me how to adjust eg. +60days to a DateTime Intervall?