Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
How to change the date "2015-02-28T15:46:00" to "2015/02/28" in the script?
Regards
How about this?
Date(Date#(Left(dt_cadastro, 10), 'YYYY-MM-DD'), 'DD/MM/YYYY') as DtCadastro_Cli,
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.
Hi Stefan,
Didn't work
Date(Floor(dt_cadastro),'DD/MM/YYYY') as DtCadastro_Cli,
How about this?
Date(Date#(Left(dt_cadastro, 10), 'YYYY-MM-DD'), 'DD/MM/YYYY') as DtCadastro_Cli,
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?
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,
Many thanks again!
No problem
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;