Load date filed

[#1]

Hello,

I have a table which contains datetime column (ex: 2014-07-18 10:00:00) say XXX.

I want to load this data into QV document as date only.

So in Load script I am using Date(XXX) as Xdate.

When i load the listbox with this field I am seeing the same value '07/18/2014', for number of rows of data.

I would like to know why is it like this instead of showing only once.

PFA the data file and load script I am using.

Thanks

[jonathandienst · Accepted solution]

Hi

Use this in the LOAD statement to strip out the time component:

LOAD ....

     Date(Floor(myDateField)) As Date,

     ...

HTH

Jonathan

[#3]

Hello Jonathan,

It works.. Thank you