M
MTRacer
I am looking for a way to tell a query to check the current day of the week
then assign a number.
For example:
Currently, my data is driven by a 'data date'. Each morning the data is
refreshed and I have a query set to only pull those records with 'Data Date =
Date()-1'.
The problem I have is that on Monday's I have to go switch it to say 'Data
Date = Date()-3' to account for the weekend.
Is there anyway that I can set it up so that 'Data Date = Date()- ((If day =
Monday, then 3 other wise 1)) ????
Thank you for any assistance!
then assign a number.
For example:
Currently, my data is driven by a 'data date'. Each morning the data is
refreshed and I have a query set to only pull those records with 'Data Date =
Date()-1'.
The problem I have is that on Monday's I have to go switch it to say 'Data
Date = Date()-3' to account for the weekend.
Is there anyway that I can set it up so that 'Data Date = Date()- ((If day =
Monday, then 3 other wise 1)) ????
Thank you for any assistance!