Hi,
I understand in queries that if I want to filter for a record attribute = Current_Date that I have to use the syntax:
FIND Client WHERE Client.CreationDate=DATE_ADD(CURRENT_DATE,0)
Could you please help me out with the syntax for a similar query that filters for clients created week-to-date:
I have tried without success a number of syntax options including:
FIND Client WHERE WEEK(Client.CreationDate)=WEEK_DIFFERENCE(CURRENT_WEEK,0)
thanks,
Pete
Filtering for CURRENT_WEEK in queries
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
I guess that I am just getting myself confused and overlooking something very simple but:
I am running MySQL. I am trying to filter for clients that were created this week.
FIND Client WHERE WEEK(Client.CreationDate)= 45
returns a client that I entered this week but
FIND Client WHERE WEEK(Client.CreationDate)=CURRENT_WEEK doesn't return anything.
Please enlighten me O'Wise One.
cheers,
Pete
I am running MySQL. I am trying to filter for clients that were created this week.
FIND Client WHERE WEEK(Client.CreationDate)= 45
returns a client that I entered this week but
FIND Client WHERE WEEK(Client.CreationDate)=CURRENT_WEEK doesn't return anything.
Please enlighten me O'Wise One.
cheers,
Pete