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
SELECT *
FROM mmstatistik
WHERE belegdatum 
BETWEEN format(getdate()-10, 'd', 'de-de')
AND format(getdate(), 'd', 'de-de')

 

still...

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

guess that GetDate() is not implementet or something :(  

Anonymous's avatar
Anonymous
Not applicable
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.

  • richardverburg's avatar
    richardverburg
    Helper I
    7 years ago

    What is your source database? Not mssql right? that was my assumption