Need help with this SQL statement

Question

1.00/5 (1 vote)

See more:

I have this SQL statement Which I'm getting a error when I try to execute.

VB

SELECT        COUNT(*) AS TotalRecords
FROM            Expenses
WHERE        ([YEAR](PostDate) = [YEAR](@MyDate)) AND (MONTH(PostDate) = MONTH(@MyDate))

I'm Using a VistaDB which has the same syntax has SQL. Any Help would be appreciated.

What I have tried:

SELECT        COUNT(*) AS TotalRecords
FROM            Expenses
WHERE        ([YEAR](PostDate) = [YEAR](@MyDate)) AND (MONTH(PostDate) = MONTH(@MyDate))

Posted 30-Mar-21 7:15am

crmfghtr

Updated 30-Mar-21 20:19pm

Add a Solution

Comments

thatraja 30-Mar-21 13:23pm

What's the error?

crmfghtr 30-Mar-21 13:39pm

How do I add an Image to this Forum

thatraja 30-Mar-21 13:44pm

Upload image into some image hosting website & include the link in your question.

OR

Simply you can update your question with Error message.

Patrice T 30-Mar-21 13:23pm

And you plan to tell what is the problem ?

crmfghtr 30-Mar-21 13:44pm

Error 509 Invalid or Incomplete Statement SELECT Line1, Column 1
Error 507 Expected Expression ) Line 1 Column 61

Patrice T 30-Mar-21 13:50pm

Use Improve question to update your question.
So that everyone can pay attention to this information.

[no name] 30-Mar-21 13:56pm

You're mangling the YEAR function.

https://www.w3schools.com/sql/func_sqlserver_year.asp

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2021-03-30T20:19:00

Try:

SQL

SELECT COUNT(*) As [TotalRecords] --or "TotalRecords"
FROM Expenses
WHERE YEAR(PostDate) = YEAR(@MyDate) AND MONTH(PostDate) = MONTH(@MyDate)

See Date and Time Functions[^] :
- YEAR[^]
- MONTH[^]

[EDIT]
In case of troubles with aliases, please read this: Getting Started - What's New - Version 5.0[^]

Quote:
Parser Fix: Does not correctly parse certain 3-part column names like: [dbo].[MyTable].ColumnName
Parser Fix: SELECT improperly accepts other unquoted keywords as table or column alias and thus can fail to recognize the start of a new statement when an optional alias can follow if no semicolon is used to separate them.

Need help with this SQL statement

1 solution

Solution 1

Add your solution here

Preview 0

Need help with this SQL statement

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us