timedate stamp convert to only mm/dd/yyyy

[#1]

I am using the direct connect and need to convert a timedate stamp to be only date below is a copy of what I have

HRxs.InitReview as 'DateRange',

[Clever_Anjos]

Try

Date(Floor(HRxs.InitReview,'MM/DD/YYYY')) as 'DateRange',

[#3]

The following error occurred:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: The floor function requires 1 argument(s).

Date(Floor(HRxs.InitReview,'MM/DD/YYYY')) as 'DateRange'

after removing the floor

Connected

The following error occurred:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: 'Date' is not a recognized built-in function name.

[MarcoWedel]

Use preceding load:

LOAD DayName(HRxs.InitReview) as DateRange;
SQL Select HRxs.InitReview
FROM YourDB;

hope this helps

regards

Marco

[#5]

hrxs:

LOAD *;
SQL SELECT
,
HRxs.eRxMsgID,
HRxs.FacID,
HRxs.InitReview as DateRange,

HRxs.NewRx,
HRxs.PackBy,
HRxs.Packed,

LOAD
DayName(HRxs.InitReview) as DateRange;
SQL Select HRxs.InitReview 
FROM Rx.dbo.HRxs

[MarcoWedel · Accepted solution]

hrxs:
LOAD *,
          DayName(HRxs.InitReview) as DateRange;
SQL
Select HRxs.eRxMsgID,
          HRxs.FacID,
          HRxs.InitReview,
          HRxs.NewRx,
          HRxs.PackBy,
          HRxs.Packed
FROM Rx.dbo.HRxs

regards

Marco

[Clever_Anjos]

It´s supposed to be at Qlik scope

LOAD *,

Date(Floor(HRxs.InitReview,'MM/DD/YYYY')) as 'DateRange';

SQL

yourquery goes here