Does anyone possess an information paper or word doc etc, showing a full range of Date expressions to use in queries.
First Date of current week
Last Date of current week
First Date of current month
Last Date of current month
First Date of Each Month
Last Date of Each Month
I need to quite a lot of calculations in queries regarding Hrs, Days, Weeks, Months, Years etc.
An information paper would be extremely useful.