Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a text object where I use function and formula to create a more dynamic title.
I've figure out how to get my desired result for Week of, but now I have another area I would like to fill in that would create an if/or situation. This is if I have selected instead of WeekEnd, MonthEnd.
My formula now is
='>> '&UPPER(Business Unit)&' CYCLE TIME - WEEK OF '&date(WeekEnd-6)&' - '&WeekEnd
Result: Business Unit Cycle Time - Week of 3/16/2015 - 3/22/2015
This formula would then be effected by a multi box I have set up for the Business Unit and WeekEnd variables
Other than the if/or situation I'm not sure how I would be able to account for the starting date of the month like I do above with "-6".
I thank you for any advice you can lend me.
Best Regards,
Myles Holland
MonthStart()
You should be able to use WeekStart() and WeekEnd() as well as MonthStart() and MonthEnd()
Hope it helps
Hi Rupert,
Thank you for responding.
Neither seem to yield a results in my text object.
Regards,
Myles
...MonthStart(WeekEnd)... ?
The WeekEnd function needs a parameter.
WeekEnd(Today())
will return the end of today's week.
Hello Bill,
There should already be a parameter.
To restate from my original post I have multibox set up. This multibox has the Business Unit, Week End and now Month End.
='>> '&UPPER(Business Unit)&' CYCLE TIME - WEEK OF '&date(WeekEnd-6)&' - '&WeekEnd works, and shows the result of : Business Unit Cycle Time - Week of 3/16/2015 - 3/22/2015.
However, I need to come up with something more dynamic that tells me the Month Ending instead.
Regards,
Myles Holland