Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Question about a date range in record selection
- Thread starter jj1576
- Start date
You could use:
datepart("q",{table.testdate}) = datepart("q",currentdate) and
year({table.testdate}) = year(currentdate)
Better yet (for speed), set up each element of the above as a SQL expression, e.g., {%testqtr}:
{fn quarter(`table`.`testdate`)}
-LB
datepart("q",{table.testdate}) = datepart("q",currentdate) and
year({table.testdate}) = year(currentdate)
Better yet (for speed), set up each element of the above as a SQL expression, e.g., {%testqtr}:
{fn quarter(`table`.`testdate`)}
-LB
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question