I finally got it to work with a slight tweak of your latest suggestion.
MyDate = Format(Mid(MyDate,4,2)+"/"+Left(MyDate,2)+"/"+Right(MyDate,4),"Mmmm yy")
Thanks again for your help. Much Appreciated.
When creating a macro in Impromptu to create a report and email it, part of the text in the subject and body is a date that is extracted from the Impromptu report.
We want the date to display in the email as "January 2007"; however it also comes through as "31/01/2007" even it we format it in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.