M
Mark_Milly
Hi Guys,
I need to now redo the below SQl to show not todays date but one week from
today to send out birthday cards etc, can anyone help me please?
Cheers Mark
I need to now redo the below SQl to show not todays date but one week from
today to send out birthday cards etc, can anyone help me please?
Cheers Mark
SELECT [All New Data].[Ref #], [All New Data].[First Name],
[All New Data].[Last Name], [All New Data].DOB,
[All New Data].Address, [All New Data].Suburb,
[All New Data].State, [All New Data].Postcode,
Month(DOB) AS BirthMonth, Day(DOB) AS BirthDay
FROM [All New Data]
WHERE Month(DOB)=Month(Date()) AND Day(DOB)=Day(Date())