Date Format "2015-02-28T15:46:00"

[Roliba001]

Good afternoon,

How to change the date "2015-02-28T15:46:00" to "2015/02/28" in the script?

Regards

[swuehl]

Try

LOAD

    Date(Floor('2015-02-28T15:46:00'),'YYYY/MM/DD') as  Date,

     ...

resp.

Date(Floor(YourField),'YYYY/MM/DD') as Date

The format should be automatically interpreted by latest Qlik versions.

[Roliba001]

Hi Stefan,

Didn't work

Date(Floor(dt_cadastro),'DD/MM/YYYY') as DtCadastro_Cli,

[sunny_talwar · Accepted solution]

How about this?

Date(Date#(Left(dt_cadastro, 10), 'YYYY-MM-DD'), 'DD/MM/YYYY') as DtCadastro_Cli,

[Roliba001]

Hi Sunny. many thanks.

It worked!

Qlikview is returning '01/01/1900" when the filed is empty. Is there a way to bring a blank field instead?

[sunny_talwar]

May be this

If(Date#(Left(dt_cadastro, 10), 'YYYY-MM-DD') > 10, Date(Date#(Left(dt_cadastro, 10), 'YYYY-MM-DD'), 'DD/MM/YYYY')) as DtCadastro_Cli,

[Roliba001]

Many thanks again!

[sunny_talwar]

No problem

[nsetty]

Can you try below

DTTable:

Load * Inline [

DT

2015-02-28T15:46:00

];

DTFinal:

Load *, DATE(Timestamp#(DT, 'YYYY-MM-DDThh:mm:ss'), 'YYYY/MM/DD') AS NewDT

Resident DTTable;

Drop Table DTTable;