sql for adding records after 02/01 of current year

[boomer1974]

I hvae the following statement in a modual: "SELECT Count(InputID) AS TotDays FROM tblInput WHERE tblInput.InputDate > #" & Format("02/01/" & Str(Year(Date) - 1), "mm/dd/yy&quot & "# AND ((tblInput.UserID)=" & glngUserID & &quot"for some reason, the 02/01/(current year) function is not being recognized as a date. Any help would be greatly appreciated.

Ryan

 

[SQLBI]

Hi,

Does changing your code thus do anything?

...& CDate(Format("02/01/" & Year(Date) - 1, "mm/dd/yy")) &...

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[SeeThru]

SQL always requires it's dates in US format - mm/dd/yy

If you use UK format normally, you need to manually convert the date for sql - you can create a custom format for it.



Like it? Star it!

 

[SQLBI]

Hi,

Actually, this may be more useful.

...& Format(CDate("02/01/" & Year(Date) - 1), "mm/dd/yy")) &...

Sorry, nearly time to go home!



Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk