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.

richardverburg's avatar
richardverburg
Helper I
7 years ago

I would use normal SQL code

 

= "SELECT * 
FROM mmstatistik 
WHERE belegdatum >= {d '01/01/2018'} AND belegdatum <= convert(date, getdate())"
  • DaFloDo's avatar
    DaFloDo
    Resolver I
    7 years ago

    hi richardverburg,

     

    I totally agree.

     

    regards

     

    florian

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      richardverburg

      I got a parsing error with WHERE clause? What that did I typed wrong?

      Or is that Convert Statement not useful for the Source Code?

      • richardverburg's avatar
        richardverburg
        Helper I
        7 years ago

        I miss a quote in the first select {d, '...'}