You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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!
Set the filter to apply on dataset as
(which is 14 days in milliseconds)
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