topic Re: How to change Date and Time ? in QlikView

How to change Date and Time ?

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to change Date and Time ?

vishsaggi — Tue, 25 Jul 2017 02:04:46 GMT

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;

Re: How to change Date and Time ?

Tue, 25 Jul 2017 02:16:58 GMT

In these type of format (19-07-2017 03:31:50) if want the date only not the time then what to do?

Re: How to change Date and Time ?

arvind_patil — Tue, 25 Jul 2017 02:31:11 GMT

HI Mahendra,

You might be help below:

Num(Floor(Timestamp#([Date Field], 'DD-MM-YYYY hh:mm:ss'))) AS NewDateField

Thanks,

Arvind Patil

Re: How to change Date and Time ?

arulsettu — Tue, 25 Jul 2017 03:08:42 GMT

try this

date(DATE#('19-07-2017 03:31:50','DD-MM-YYYY hh:mm:ss'),'DD/MM/YYYY') as date_field

Re: How to change Date and Time ?

Anil_Babu_Samineni — Tue, 25 Jul 2017 03:21:01 GMT

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

Re: How to change Date and Time ?

vishsaggi — Tue, 25 Jul 2017 12:17:35 GMT

Just load like

Date(Date#(YourdateField, 'DD-MM-YYYY hh:mm:ss'), 'DD-MM-YYYY') AS OnlyDate

Re: How to change Date and Time ?

ramasaisaksoft — Tue, 25 Jul 2017 14:34:19 GMT

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

Re: How to change Date and Time ?

shiveshsingh — Wed, 26 Jul 2017 08:13:19 GMT

=DATE(date#('19/07/2017 3:31:50','DD/MM/YYYY h:mm:ss'),'DD/MM/YYYY')

Re: How to change Date and Time ?

chinnuchinni — Wed, 26 Jul 2017 09:07:00 GMT

Hi,

You can go through this,You will get idea

How to Use Simple Date Functions in QlikView and Qlik Sense | EzDataMunch

Re: How to change Date and Time ?

Kushal_Chawda — Wed, 26 Jul 2017 09:17:07 GMT

Use floor function to convert it into Date form, floor will also remove repeating of dates in listbox

floor(YourDateField)

Make sure that your date is in Number format, else you need to use below expression

floor(Date#(YourDateField,'DD-MM-YYYY hh:mm:ss'))

Re: How to change Date and Time ?

Anonymous — Wed, 26 Jul 2017 10:45:30 GMT

Hi Mahendra,

Try the following Expression:

Date( Left ( Date# ( YourdateField ) ,5 ) , 'DD-MM-YYYY' ) AS Date

Regards

Vinod Gadiputi