DateTime format

[#1]

Hi Guys

I have a field that displays the datetime format. I would only like it to display the date. In my load script it is as follows.

"dDate_on_board"

as [Estimate dDate_on_board],

It displays as follows

Is there a way i can resolve this with the load script.

Help is much appreciated

[sunny_talwar]

I assume you are doing this in load statement and not SQL Select. If that's true, try this:

Date(Floor("dDate_on_board")) as [Estimate dDate_on_board],

or this if date is read as text string by QV

Date(Floor(Date#(Left("dDate_on_board", 10), 'YYYY-MM-DD'))) as [Estimate dDate_on_board],

[#3 · Accepted solution]

Thanks so much. Tried this and it worked

trim(date(date("dDate_arrival",'YYYY/MM/DD hh:mm:ss[.fff] TT'),'YYYY/MM/DD ') )

   AS [Estimate dDate_arrival];