A
anthonysjo
Experts,
This is probalby an easy one but I have not had a lot of time to research
and I figure someone can quickly point me in the right direction.
I am trying to run a timesheet report that will pull the past week's and
current week's timesheet. The criteria will be set on a field called period
that is fomatted as follows: WE mmddyy The period field only contains one
entry per week, since our time periods close on Saturdays. For example the
period entry for last week would look like the following: WE 061105
Currently I am using a between statment with 2 prompt boxes to have the user
enter the 2 weeks that they want returned. However, I would like to automate
this process by removing the possibility of user error when typing in the
period date.
Below is an example of the crruent statement I am using to prompt the user.
Between [Enter 1st desired period: Format (WE mmddyy)] And [Enter 2nd
desired period: Format (WE mmddyy)]
I also tried to use the following expression on the Period field but I was
getting inconsistent results, as the query would return extra periods outside
of the defined range:
Week Ending: val (right(
.[period], 6))
Can someone help me out?
This is probalby an easy one but I have not had a lot of time to research
and I figure someone can quickly point me in the right direction.
I am trying to run a timesheet report that will pull the past week's and
current week's timesheet. The criteria will be set on a field called period
that is fomatted as follows: WE mmddyy The period field only contains one
entry per week, since our time periods close on Saturdays. For example the
period entry for last week would look like the following: WE 061105
Currently I am using a between statment with 2 prompt boxes to have the user
enter the 2 weeks that they want returned. However, I would like to automate
this process by removing the possibility of user error when typing in the
period date.
Below is an example of the crruent statement I am using to prompt the user.
Between [Enter 1st desired period: Format (WE mmddyy)] And [Enter 2nd
desired period: Format (WE mmddyy)]
I also tried to use the following expression on the Period field but I was
getting inconsistent results, as the query would return extra periods outside
of the defined range:
Week Ending: val (right(
Can someone help me out?