Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Use Week(Today())
Hi Try this
='Week Number ' & ' - ' & Week(Today())
Thanks Stefan,
it works.
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
Thanks Nag,
actually this is not what I'm looking for.
but thank for your help and support.