set variable as:
Evaluate(Left ( MonthName(Date(Month(Get(CurrentDate)) - 1;1;Year(Get
(CurrentDate)))) ; 3 ))
Left function is only to evaluate if your field names are all made
with 3 letter length.
There are other ways to do this, but I think this will get you what
you need without much tweaking.
I hoe this will help. Take care and have a nice holiday.
Your frequent FM talker:
Pavle Ancevski Pajo
New York Hotel Trades Council
[hidden email]
On Jul 3, 2009, at 10:28 AM,
[hidden email] wrote:
> Hi all,
>
> I have 12 fields on a layout...
>
> Jan
> Feb
> Mar
> ... And so on
>
> In a script I would like to copy the value of the field of the
> previous month but I cannot see a way to specify the field to be
> copied based on todays month - 1
>
> Any ideas please folks?
>
> Many thanks
> Ed
>
> Sent from my BlackBerry® wireless device
> --
> This list is a free service of LassoSoft:
http://www.LassoSoft.com/> Search the list archives:
http://www.ListSearch.com/FileMaker/Browse/> Manage your subscription:
http://www.ListSearch.com/FileMaker/>
>
--
This list is a free service of LassoSoft:
http://www.LassoSoft.com/Search the list archives:
http://www.ListSearch.com/FileMaker/Browse/Manage your subscription:
http://www.ListSearch.com/FileMaker/
