P Piet Linden Mar 27, 2009 #2 Trying to show last monthis a text box "Feburary" =Date()-1"M" Click to expand... ?format(dateadd("m",-1,date()),"mmmm")
Trying to show last monthis a text box "Feburary" =Date()-1"M" Click to expand... ?format(dateadd("m",-1,date()),"mmmm")
B Bob Vance Mar 27, 2009 #3 Thanks Piet, but its giving me a #Name! I entered your code in Control Source? Regards Bob Trying to show last monthis a text box "Feburary" =Date()-1"M" Click to expand... ?format(dateadd("m",-1,date()),"mmmm")
Thanks Piet, but its giving me a #Name! I entered your code in Control Source? Regards Bob Trying to show last monthis a text box "Feburary" =Date()-1"M" Click to expand... ?format(dateadd("m",-1,date()),"mmmm")
B Bob Vance Mar 27, 2009 #4 OK got it Now Thanks =format(dateadd("m",-1,date()),"mmmm") Trying to show last monthis a text box "Feburary" =Date()-1"M" Click to expand... ?format(dateadd("m",-1,date()),"mmmm")
OK got it Now Thanks =format(dateadd("m",-1,date()),"mmmm") Trying to show last monthis a text box "Feburary" =Date()-1"M" Click to expand... ?format(dateadd("m",-1,date()),"mmmm")