Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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];
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],
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];