Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

SQL Query with Actual Date

Hello,   I Have a question. What must I write in the M Statement or SQL Statment to get WHERE explicit Date to NOW Date?   Quelle = Odbc.Query("dsn=mmStatistik", "SELECT * FROM mmstatistik#(I...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago
    SELECT *
FROM mmstatistik
WHERE belegdatum 
BETWEEN {d '01/01/2018'}
AND Date()

    was rellay simple...and a lucky type...

     

    that works and gives me the actual date

     

    Thanks for alle the help and sorry for the circumstances.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

that's the error i get when i use that code

 

Spoiler
DataSource.Error: ODBC: ERROR [HY000] [SAP][Advantage SQL Engine][ASA] Error 7200:  AQE Error:  State = S0000;   NativeError = 2121;  [SAP][Advantage SQL Engine]Column not found: date -- Location of error in the SQL statement is: 61 (line: 4 column: 17)
Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=mmStatistik
    OdbcErrors=Table

 

 

richardverburg's avatar
richardverburg
Helper I
7 years ago

I made a typo this is the correct code:

 

SELECT *
FROM mmstatistik
WHERE belegdatum 
BETWEEN convert(date, getdate()-10)
AND convert(date, getdate())