Page 1 of 1

Last Month Name Setting

PostPosted: Tue Jan 05, 2010 7:13 am
by mgxdigital
I have a field that shows the last month's name, year on the same layout as my monthly calendar.
My calulcation is this:
Let( [ now = (CalFilterDateGlob ) ;
prev = Date ( Month(now) - 1 ; Day(now) ; Year(now) ) ] ;
MonthName ( prev ) & "," & " " & Year (now)
)

Now with the year change, this calculation is not working and i'm not sure how to get it to work with the year changing as you flip through the calendar.

PostPosted: Wed Jan 13, 2010 12:27 pm
by John Sindelar
Replace you last instance of "now" with "prev" like this:

Let( [ now = (Get(Currentdate) ) ;
prev = Date ( Month(now) - 1 ; Day(now) ; Year(now) ) ] ;
MonthName ( prev ) & "," & " " & Year (prev)
)