Label for week

[Anonymous]

Hi guys,

How can I change Number of week for label of this week.

For example:

2012/35     to       21 Oct 2012 - 27 Oct 2012.

Tahnks,

[swuehl]

If you have used weekname() function to create your week numbers, you've got a dual with a numeric value representing start of that week. You can then try:

=Date(WeekNrField, 'DD MMM YYYY') & ' - ' & Date(weekend(WeekNrField), 'DD MMM YYYY')

Regards,

Stefan

[Clever_Anjos]

=WeekStart(Today()) &'-'& date(WeekStart(Today()) +7)

[Anonymous · Accepted solution]

I got like it

WeekStart(date(submitDateTime))& '-'  &WeekEnd(date(submitDateTime)) as AAA

[Anonymous]

I need to use this variable in charts.

I can't sort it.

Do you have any ideas?

[Anonymous]

I think I got it.

Sort by load order

[Clever_Anjos]

Use "dual" function

dual(WeekStart(date(submitDateTime))& '-'  &WeekEnd(date(submitDateTime),WeekStart(date(submitDateTime))) as AAA

[Anonymous]

Hello,

could you help me to create expression with dual?

Thanks,

[Clever_Anjos]

Into your script maybe you are loading something like this:

LOAD

submitDateTime,

anotherfield,

anotherfiel2

from yourtable.qvd(qvd);

Use a command like this

LOAD

submitDateTime,

dual(

          WeekStart(submitDateTime)& '-'  &WeekEnd(submitDateTime),

          WeekStart(submitDateTime)

) as my_new_field,

anotherfield,

anotherfiel2

from yourtable.qvd(qvd);

[Anonymous]

Thank you,

I got it.

I put ) not in right place.