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

[davin]

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!

[Katerina Kovriga {Stiltsoft}]

Hi @davin ,

If you use our Table Filter and Charts for Confluence app, you may try to filter the result TableView macro using date periods (1m, 2w, today,...) via the Table Filter macro as well:

[Alex Medved _ConfiForms_]

Hi

Set the filter to apply on dataset as 

created:>([today]-14)

or

created:>([entry._now.add(-1209600000)]))

(which is 14 days in milliseconds)

Alex

[ASQS]

Thanks Alex,

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

[Alex Medved _ConfiForms_]

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]

Thank you, End Date was my missing hint.