topic DateTime format in QlikView

DateTime format

Thu, 04 Feb 2016 07:50:01 GMT

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 — Thu, 04 Feb 2016 17:18:07 GMT

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],

Fri, 05 Feb 2016 05:54:52 GMT

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];