HI,
I need to check that the current date is between 2 dates in a last (start date and To date)
I have tried the usual if greater than or equal and less than or equal but nothing works the query always returns no results
Anyone know how to do this?
Answer
Date falls between date range
+1Best answer by Garrett
Hi
That works too. Your query expression is correct.
I suspect that perhaps the FromDate is greater than the ToDate
or the dtCurrent date is outside of the FromDate < ToDate range.
Use control values for the Dates. FromDate is 1 Jan 2023, ToDate is 31 Dec 2023.
Use the Conditional Branch. Place a Log to History at both outcome Yes and No.
Use another Log to History to display the values of all 3 dates
+16Hi
- The 2 dates in the SP List. Confirm that the days are of DateTime type.
- Can you post a screenshot of the Query
+16Hi
Here is an example of comparison. Instead of using dates from the SP List, I will just create variables and set the date values in this example. You should use Dates from the SP columns - however pls verify that DateTime1 <= DateTime2 otherwise the expression will always return False or No
- Use a Set Workflow Variable action to create 3 Datetime variables.
Datetime1 - This is the start Date. 1-Apr
Datetime2 - This is the end Date. 10-Apr
DateToday - This is the current Date
- Check if DateToday is between Datetime1 and Datetime2.
Datetime1 <= DateToday <= Datetime2
Use a Conditional Branch to enter the following expression.
Final Code.
+16Hi
That works too. Your query expression is correct.
I suspect that perhaps the FromDate is greater than the ToDate
or the dtCurrent date is outside of the FromDate < ToDate range.
Use control values for the Dates. FromDate is 1 Jan 2023, ToDate is 31 Dec 2023.
Use the Conditional Branch. Place a Log to History at both outcome Yes and No.
Use another Log to History to display the values of all 3 dates
+16Hey
Glad to help
Cheers
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.