topic Re: Format date include day name in QlikView

Format date include day name

Thu, 09 May 2013 08:52:19 GMT

Hi all,

Anyone know how to convert or format this date: Wed, 01-July-2011 into this format: 01/07/2011. I have tried this expression:

=date(Date#([myDateField], 'ddd, DD-MMM-YYYY'),'DD/MM/YYYY') but can't work...

Anyone has any idea to do this? Any comments and suggestions are welcome.

Another problem is my database consists a variety of date with different format and those format are unexpected since my date date will always being updated... I am thinking a way to convert those unexpected date format into this format 'DD/MM/YYYY'. But I am not sure is it possible. Anyone has any ideas on this? Please let me know if my questions are not clear...

Thanks a lot.

Re: Format date include day name

Thu, 09 May 2013 08:58:06 GMT

use WWW on the place of ddd

Re: Format date include day name

Thu, 10 Jul 2014 10:22:30 GMT

ok so what if i have a date feild and i want to have a list box showing only the 7 days of the week, how would i go about doing that

Re: Format date include day name

Thu, 10 Jul 2014 10:25:47 GMT

Day(dateField)

Re: Format date include day name

Anonymous — Thu, 10 Jul 2014 10:26:01 GMT

Try below for weekdays,

=WeekDay(Today())

Re: Format date include day name

Thu, 10 Jul 2014 10:30:19 GMT

Hi there, thanks but it does not show distinct, weekday does however

Re: Format date include day name

Thu, 10 Jul 2014 10:31:19 GMT

how do i get them to sort chronologically

Re: Format date include day name

Anonymous — Thu, 10 Jul 2014 10:32:17 GMT

Hi,

You may try below,

date_field = Wed, 01-July-2011

=Date(Date#(Trim(SubField(date_field, ' ',2)), 'DD-MMM-YYYY'))

Re: Format date include day name

kaushalview — Thu, 10 Jul 2014 10:36:51 GMT

Use this expression

date(today(), 'DD-MMM-YYYY')&'-'&WeekDay(today())

Regards

Kaushal

Re: Format date include day name

Anonymous — Thu, 10 Jul 2014 10:37:00 GMT

You can sort them by Numeric Value to get chronological order. Or you may have to create inline table to get this done.

Re: Format date include day name

Anonymous — Thu, 10 Jul 2014 10:44:00 GMT

Hi,

"Another problem is my database consists a variety of date with different format and those format are unexpected since my date date will always being updated"

You can use ALT function to add different format and convert them into date field. See below,

date1 = Wed, 01-July-2011

date2 = 01-July-2011, Wed

date3 = Wed, 01-July-11

ALT(Date#(Trim(SubField(date1, ' ',2)), 'DD-MMM-YYYY'),

Date#(Trim(SubField(date2, ',',1)), 'DD-MMM-YYYY'),

Date#(Trim(SubField(date3, ' ',2)), 'DD-MMM-YY'), 'No valid date' ) as Date_Field

Re: Format date include day name

maxgro — Thu, 10 Jul 2014 11:21:18 GMT

Set LongMonthNames = 'January;February;March;April;May;June;July;August;September;October;November;December';

=date(date#(subfield('Wed, 01-July-2011', ' ',2), 'DD-MMMM-YYYY'), 'DD/MM/YYYY')

see here for MMMM

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/05/month-names

Re: Format date include day name

Thu, 10 Jul 2014 11:22:14 GMT

HI cthesky87

you can override document settings to format the field in the number tab

1. Open properties and go to the number tab

2. Select field

3. Tick override document settings

4. Select date and use format pattern to suit you needs

Regards

Padma

Re: Format date include day name

PDurnall — Tue, 05 Sep 2023 13:40:16 GMT

=Date([Datefield],"WWW") worked great thank you 🙂