Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to change the date & time format when given at the same time like (19-07-2017 03:31:50).
Any one can you please help to change these kind of formats.
Did you try this?
LOAD *,
Date(YourDateField, 'DD-MM-YYYY hh:mm:ss') AS ActualDateNum;
LOAD fieldname1,
fieldname2,
Num(Floor(Date#(YourDateField, 'DD-MM-YYYY hh:mm:ss'))) AS yourDateField
FROM yourdatasource;
In these type of format (19-07-2017 03:31:50) if want the date only not the time then what to do?
HI Mahendra,
You might be help below:
Num(Floor(Timestamp#([Date Field], 'DD-MM-YYYY hh:mm:ss'))) AS NewDateField
Thanks,
Arvind Patil
try this
date(DATE#('19-07-2017 03:31:50','DD-MM-YYYY hh:mm:ss'),'DD/MM/YYYY') as date_field
If your variable format same as your date format then you don't need any thing here. Just use Date(FieldName) to get Date and same as Time
Just load like
Date(Date#(YourdateField, 'DD-MM-YYYY hh:mm:ss'), 'DD-MM-YYYY') AS OnlyDate
Hi Mahendra,
Date(Date#('19-07-2017 03:31:50','DD-MM-YYYY HH:MM:SS'),'DD/MM/YYYY') as Joining Date
it will returns 19/07/2017
Day(Date#('19-07-2017 03:31:50','DD-MM-YYYY HH:MM:SS')) as Joining Date
19
=DATE(date#('19/07/2017 3:31:50','DD/MM/YYYY h:mm:ss'),'DD/MM/YYYY')
Hi,
You can go through this,You will get idea
How to Use Simple Date Functions in QlikView and Qlik Sense | EzDataMunch