Get current week number?

[#1]

I have a calendar table, I need to set a filter always to current week number

Week number is already in the calendar tale

Now based on today date. I can get the week number

But the furmual is not working

vToday = today()

=max( {< CalendarDate= {'$(vToday)
'} >}  CatalogWeek)

Any idea how this can work?

[struniger · Accepted solution]

Try to add this to your calendar table as a flag, then select the flag = 1

inweek(CalendarDate, '$(vToday)', 0) * -1 AS CW

Best regards

Stefan

[mahesh_agrawal]

Use Week(Today())

[Anonymous]

Hi Try this

='Week Number ' & ' - ' & Week(Today())

[#5]

Thanks Stefan,

it works.

[aveeeeeee7en]

Try this:

=Only ({<Week= {'$(=Max(Week))'} >} Date)

Here Week is which you have created by using your date field eg.  Week(DateField) AS Week and Date is your DateField

See the Attachment.

Regards

Aviral Nag

[#7]

Thanks Nag,

actually this is not what I'm looking for.

but thank for your help and support.