Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have been calculating the current month with the expression:
=Date(Max(MakeDate(2018,MonthNum,1)),'MMM') & ' ' & Max(Year)
And the previous month with:
=Date(MonthStart(Max(MakeDate(2018, MonthNum, 1)), -1), 'MMM YYYY')
How would I go about updating it so it picks up 2019? I tried changing 2018 to 2019 but that is not working, any ideas?
Thanks!
So, you are showing this in a text box object? Is this completely based on today's date? Why don't you just use
For current Month
=Date(MonthStart(Today()), 'MMM YYYY')
For Previous Month
=Date(MonthStart(Today(), -1), 'MMM YYYY')
Hi Sunny,
I have this in my master calendar:
Mastercalendar:
Load
TempDate as ActualDate,
monthname(TempDate) as YearMonth,
monthname(TempDate) as MonthYear,
num(month(TempDate)) as MonthNum,
day(TempDate) as Day,
weekday (TempDate) as WeekDay,
week(TempDate) as Week,
year(yearstart(TempDate,0,4)) as FiscalYear,
InYearToDate(TempDate,$(vToday),0) * -1 as CurYTDFlag,
InYearToDate(TempDate,$(vToday),-1) * -1 as LastYTDFlag
So I'm trying to show the max Month and max year in a text box. I'm doing this so I can update my reports in NPrinitng.
So, you are showing this in a text box object? Is this completely based on today's date? Why don't you just use
For current Month
=Date(MonthStart(Today()), 'MMM YYYY')
For Previous Month
=Date(MonthStart(Today(), -1), 'MMM YYYY')
Hey Sunny,
Thank you that is working. I think my issue was with the filter I had in NPrinting but I was able to update that also.
Thank you for your help!!!