topic Re: Date format in QlikView

Date format

SatyaPaleti — Thu, 30 Jul 2015 18:17:30 GMT

Hi Friends,

I am Having a date 6/16/2015 6:00:08 AM

I want to show this date (6/16/2015 6:00:08 AM) as '16-june-2015' How can we do this?

Thank you,

SatyaPaleti

Re: Date format

sasiparupudi1 — Thu, 30 Jul 2015 18:22:54 GMT

=date(date#(SubField('6/16/2015 6:00:08 AM',' ',1),'M/DD/YYYY'),'DD-MMMM-YYYY')

Re: Date format

Gysbert_Wassenaar — Thu, 30 Jul 2015 18:23:06 GMT

date(floor(date#('6/16/2015 6:00:08 AM','M/D/YYYY h:mm:ss TT')),'D-MMMM-YYYY')

Re: Date format

robert_mika — Thu, 30 Jul 2015 18:35:52 GMT

=DATE(Date#(TextBetween ('6/16/2015 6:00:08 AM','',' '),'M/DD/YYYY'),'D-MMMM-YYYY')

Re: Date format

SatyaPaleti — Thu, 30 Jul 2015 18:41:30 GMT

I am Having Field like this I want to show like following

Re: Date format

sasiparupudi1 — Thu, 30 Jul 2015 18:44:55 GMT

=date(date#([Creation date],'M/DD/YYYY'),'DD-MMM-YYYY')

Re: Date format

Kushal_Chawda — Thu, 30 Jul 2015 18:51:54 GMT

=date([Creation Date],'DD-MMMM-YYYY')

Re: Date format

Thu, 30 Jul 2015 20:35:20 GMT

Yes, as Kush said this will work

=Date(date_closed,'DD-MMM-YYYY')

Re: Date format

MarcoWedel — Thu, 30 Jul 2015 22:11:27 GMT

another one:

Date(DayName(Timestamp#('6/16/2015 6:00:08 AM','M/DD/YYYY h:mm:ss TT')),'DD-MMMM-YYYY')

regards

Marco

Re: Date format

qlikviewwizard — Fri, 31 Jul 2015 06:45:03 GMT

Hi SatyaPaleti

Please use this simple script:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='DD-MMMM-YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Table:

LOAD date(Date) as Date INLINE [

Date

6/16/2015 6:00:08 AM

5/16/2015 6:00:08 AM

4/16/2015 6:00:08 AM

3/16/2015 6:00:08 AM

2/16/2015 6:00:08 AM

1/16/2015 6:00:08 AM

];

Re: Date format

_rohitgharat — Fri, 31 Jul 2015 08:53:52 GMT

Hii Satya Paleti,

use Date('DateField','DD-MMMM-YYYY') and you will get your answer.

Regards,

Rohit

Re: Date format

sasiparupudi1 — Fri, 31 Jul 2015 08:56:39 GMT

If you got your answer, please close this thread by marking the correct one

Regards

Sasi

Re: Date format

qlikviewwizard — Fri, 31 Jul 2015 08:58:40 GMT

Hi SatyaPaleti,

Did you resolve your issue? Please let us know. Thank you.