Date Format from DD/MM/YYYY hh:mm:ss to DD/MM/YYYY

[#1]

Hi everybody,

I want to convert the date format from DD/MM/YYYY hh:mm:ss to DD/MM/YYYY.

I know there are many post about this problem but that didn't work.

I'm new in Qlik so maybe it's a stupid error that I do...

This is the script. I need to convert the field  DataDocumento as I explained above.

ODBC CONNECT TO [MS Access Database;DBQ=G:\Applicazioni\ARX\ARXivar_r01.accdb];

SQL SELECT DOCNUMBER,

    Protocollo,

    DataDocumento

FROM `T_zmd_002_Offerte`;

Please help me

Thank you in advance.

[MK_QSL]

ODBC CONNECT TO [MS Access Database;DBQ=G:\Applicazioni\ARX\ARXivar_r01.accdb];

Load

     DOCNUMBER,

     Protocollo,

     Date(Floor(DataDocumento)) as DataDocumento;

SQL SELECT DOCNUMBER,

    Protocollo,

    DataDocumento

FROM `T_zmd_002_Offerte`;

or replace with below

Load

     DOCNUMBER,

     Protocollo,

     Date(Floor(TimeStamp#(DataDocumento,'DD/MM/YYYY hh:mm:ss')),'DD/MM/YYYY') as DataDocumento;

SQL SELECT DOCNUMBER,

    Protocollo,

    DataDocumento

FROM `T_zmd_002_Offerte`;

[avinashelite]

try like this :

Date(Floor(DataDocumento),'DD/MM/YYYY') as DataDocumento;

[Digvijay_Singh]

Try like this -

Date(Date#(DataDocumento,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YYYY')

[qlikview2015]

Hi minamina,

please try this:

date(DataDocumento,'DD/MM/YYYY' as DataDocumento

Best Regards

Mike Preuss

[lightning]

Thx, it works for me !

[avinashelite]

If you have got the answer please mark the correct and helpful answers