Date

[#1]

Hi

I have in the DB "Datetime" this is "dd.MM.YYYY mm.hh". Like this "12.08.2013 10:45". How can I load just the date "12.08.2013"?

[tresesco]

put a comma after DATETIME. And yes, you are trying to use qv function under SQL. that won't work.

try like:

LoadedTable:

Load *,

          Date(Floor(Date#(DATETIME, 'DD.MM.YYYY mm.hh'))) As Date ;

ODBC CONNECT TO [xxx](xxx,xxx)

SQL SELECT Id,

                    action,

                    DATETIME 

FROM XX."XX";

[#3]

Now i can load it, but the listbox Date is empty

how do i have to set the "DD.MM.YYYY mm.hh" if it is 12.08.2013 10:12:20.000000000

[tresesco · Accepted solution]

This?

LoadedTable:

Load *,

          Date(Floor(Date#(DATETIME, 'DD.MM.YYYY mm.hh.fff'))) As Date ;

ODBC CONNECT TO [xxx](xxx,xxx)

SQL SELECT Id,

                    action,

                    DATETIME

FROM XX."XX";

And if this too not working, try simply:

Date(Floor(DATETIME)) As Date

[#5]

Now it works. With just Date(Floor(DATETIME)) as Date

Thank you verry much

[#6]

Now I have a Date

Can I load the Data with Where Date >= '19.08.2013'?