Good afternoon, I'm fairly new to date formats in SQL and could do with a little guidance on how to change the format from an nvarchar field with a date format of DD/MM/YYY to something I can use GetDate() with. For example, select * from tablename where Date_of_Last_Attempt >= Getdate()-7 Than…

Dates should really be held as dates but if you really have to cope with strings: [image] CAST and CONVERT (Transact-SQL) - SQL Server Reference for the CAST and CONVERT Transact-SQL functions. These functions convert expressions from one data type to another.

Convert NVARCHAR to date format to use with Get Date

Transact-SQL

Ifor June 29, 2020, 11:30am 2

Dates should really be held as dates but if you really have to cope with strings: