function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rachel KrzyzanowskiRachel Krzyzanowski 

Get Records: last 7 days of records in flow

I'm trying to create a schedule flow that would pull all records created within the last 7 days into a collection. I can't seem to get the formula right to get these records..
Rachel KrzyzanowskiRachel Krzyzanowski
{!$Flow.CurrentDate} + 7 
I dont think this formula would work because it would just pull records created 7 days ago...
Alain CabonAlain Cabon
It is a formula indeed (not a variable) and just replace "+" with "-" (minus). 

{!$Flow.CurrentDate} - 7   with parenthesis that should also work: ( {!$Flow.CurrentDate} - 7 )     (former bug)

User-added image

DEBUG MODE

FAST LOOKUP: get_last_created_accounts
Find all Account records where:
CreatedDate Greater than {!currentdateminus7} (12 July 2020)
Sort records by: Name (Ascending)
Store the values of these fields in get_last_created_accounts: Id, Name, CreatedDate


User-added image

 
Rachel KrzyzanowskiRachel Krzyzanowski
Thank you Alain!! Will this formula include records for the current date of the flow as well? 

So for example:All records created on: (8/5/2020) and 8/4/2020, and 8/3/2020, and 8/2/2020. and 8/1/2020, and 7/31/2020, and 7/30/2020?
ankur kumar 79ankur kumar 79
This is new online game Fruit Collection game (https://fundecade.com/fruit-collection) this is simple skill mode game.