syntax error

Results 1 to 2 of 2

Thread: syntax error

  1. #1
    Join Date
    Dec 1969

    Default syntax error

    Table Application and column iYear, iMonth<BR><BR>DATEDIFF(MONTH,Application.iYear+/+Application.iMonth+/+01,GETDATE())<BR><BR>what would be correct syntax<BR><BR>Thank You

  2. #2
    Join Date
    Dec 1969

    Default Show the FULL query...

    I *presume* this is a SQL Server DB, since you used GetDate?<BR><BR>And where does the Application field come from?<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts