g118481
asked on
How to Format Getdate() for the week?
Experts,
I am using this "Format(Now(),'ww') = Format(C.curdate,'ww')" to format and compare the function Now with a date field, in an app query for MS Access.
I am migrating to SQL Server and need to convert this line in the query.
So far I have "Format(Getdate(),'ww') = Format(C.curdate,'ww')" , but I am getting an error on "Format".
What can I change that to in order for it to work in SQL Server?
Cheers
I am using this "Format(Now(),'ww') = Format(C.curdate,'ww')" to format and compare the function Now with a date field, in an app query for MS Access.
I am migrating to SQL Server and need to convert this line in the query.
So far I have "Format(Getdate(),'ww') = Format(C.curdate,'ww')" , but I am getting an error on "Format".
What can I change that to in order for it to work in SQL Server?
Cheers
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. This works perfect.