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?
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!