You need to sign in to do that
Don't have an account?
PCRecycler
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?
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?