function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Date Variable for Date and Time Field Flow

Need Help! - I have two flow variables that are date fields.  The values are being passed from a record into those variables.  These variables are a date range that is used in the flow.  Example 5/16/2016 to 5/31/2016.  The variables are being used on a created date field. The way the variables are being inserted is CreatedDate >= Variable1 (5/16/2016) and CreatedDate <= Variable2 (5/31/2016).  It works fine except for one thing.  If a record has a created date of 5/31/2016, it does not pick up the record in the flow query.
My only thought is that CreatedDate is a date and time field, and I'm only passing a date.  When I try and change the flow to run on just 5/31/2016 and remove the variable the value that it defaults to is 05/31/2016 12:00 AM GMT-0400.  Does that mean the query is only looking at 5/31/2016 midnight (5/31/2016 00:00:00z) and earlier so any records made during the day of 5/31 (5/31/2016 1:00:00)  it won't pickup?