I'm confused...

1.) Where is the FORMAT(...) coming from C++ or SQL???? Let me know and I will try to help more!

2.) Your Statement:

FORMAT(Start_Date, "yyyy") BETWEEN 1998 AND 1998 AND FORMAT(Start_Date, "ww") BETWEEN 24 AND 24

BETWEEN (in BOTH places) is NOT needed...just say:

FORMAT(Start_Date, "yyyy") = 1998 AND FORMAT(Start_Date, "ww") = 24

3.) Since I've looked in SQL Books Online & VC++ and can't find this FORMAT??? The following is a guess:

FORMAT(Start_Date, "ttttt") ...... Possibly use only 4 t's and not 5.


Thanks in advance,

Dan