topic Re: Date format Help! in QlikView

Date format Help!

amit_saini — Thu, 30 Jun 2016 10:46:41 GMT

Hi Folks,

Below is my source date format

Tue May 24 06:43:44 BST 2016

Tue May 24 06:50:17 BST 2016

How can I convert this to 'DD-MM-YY HH;MM:SS ' format ????

Thanks,

Re: Date format Help!

Chanty4u — Thu, 30 Jun 2016 10:52:01 GMT

try

Date(date#(Daefield,'Tue May 24 06:43:44 BST 2016'), 'DD-MM-YY HH;MM:SS) as newdate

Re: Date format Help!

migueldelval — Thu, 30 Jun 2016 10:54:40 GMT

Hi Amit,

If for example your date field it´s called "DATE".

date#(DATE, 'DD-MM-YY HH;MM:SS ') as Date_2,

Tri it and tell me if it´s ok

Regards

Miguel del Valle

Re: Date format Help!

PrashantSangle — Thu, 30 Jun 2016 10:56:41 GMT

Hi,

try like

=date(date#(mid(Replace('Tue May 24 06:43:44 BST 2016','BST',''),5),'MMM DD hh:mm:ss YYYY'),'MM/DD/YYYY')

Regards

Re: Date format Help!

MK_QSL — Thu, 30 Jun 2016 10:58:40 GMT

Date(Date#(Mid(DateField,5,6) & ' ' & Right(DateField,4) & ' ' & Mid(DateField,12,8),'MMM DD YYYY hh:mm:ss'),'DD-MM-YY hh:mm:ss') as YourNewDateField

Front End

=Date(Date#(Mid(DateField,5,6) & ' ' & Right(DateField,4) & ' ' & Mid(DateField,12,8),'MMM DD YYYY hh:mm:ss'),'DD-MM-YY hh:mm:ss')

Re: Date format Help!

PrashantSangle — Thu, 30 Jun 2016 11:02:14 GMT

Hi,

update date format as per requirement.

I have set MM/DD/YYYY you can replace it with your required format DD-MM-YY HH;mm:SS

Regards

Re: Date format Help!

MK_QSL — Thu, 30 Jun 2016 11:08:48 GMT

Replace

Date# with TimeStamp# and

Date with TimeStamp

in my above expressions...

Re: Date format Help!

mikael_bjaveclo — Thu, 30 Jun 2016 13:40:17 GMT

I'm Swedish and I would maybe have presented the timestamps in my local time, and with my local settings (

SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]'; ).

This is the way of doing it.

Load *,
ConvertToLocalTime(BrittishTimeStamp, 'London', 0) As LocalTimeStamp;
LOAD *,
TimeStamp(TimeStamp#(Mid(Date, 5, 6) & ' ' & Right(Date, 4) & ' ' & Mid(Date, 12, 8), 'MMM DD YYYY hh:mm:ss'), '$(TimestampFormat)') As BrittishTimeStamp
FROM...