A way to display dates as <Day> - <Weekday>

[#1]

Hi,

Is there a way that I can get an expression that shows my days of the week as (for e.g) "13 - Wed" assuming that this is the Day/ Weekday combination of the 13th of Jan 2016 which is a Wednesday.

In short, I have loaded Day(date) and Weekday(date) into my data but I'm wondering if there is an expression that combines the two.

Thanks,

D

[sunny_talwar]

Try this may be:

=Date(Today(), 'DD - WWW')

[#3]

Hi Sunny,

I tried that but all it does is give me todays date in a column with the day like 27-Wed.

What I need is to Load a column which loads the date and day based on the date column.

Thanks for your help anyway.

D

[sunny_talwar]

Well the above was to show how you can format date in that particular format. For changing your date to that format in the script, you can try the following:

Date(DateField, 'DD - WWW') as [Day-Week],

Here is a sample to look at:

Table:

LOAD Date,

  Date(Date, 'DD - WWW') as [Day-Week];

LOAD Date(MakeDate(2014, 12, 31) + RecNo()) as Date

AutoGenerate 721;

[#5]

Thanks Sunny,

Adding Date(DateField, 'DD - WWW') as Day-Week to the Load script worked perfectly.

Regards,

D

[sunny_talwar]

Awesome. I am glad you were able to figure it out.

Would you mind closing this thread by marking correct and any helpful answers? Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny