how do i pull the month of the current date and get it as a number instead of text? is it possible?

I'm not sure if this will answer your question but.....

Create a calculation field as follows:

Case(

Month=Jan (or January),"1",

Month=Feb (or February),"2",

Month=Mar (or March),"3",........

Month=Dec (or December),"12","")

If your field contains the entire date, ie: Jan 1, 2001, you have two options.

1. Create a Month field that is a calculation:

Month=left(date,3)

2. In your Case statement above substitute left(date,3) for Month.

[ June 27, 2001: Message edited by: esteshk ]

sorry....I should have been more specific... I needed an applescript solution. When you ask for the current date, you only get the month as text, I was just wondering if there's a way to call the current date and get the month as an integer.

Why not use Month(Status(CurrentDate)) and set the field type as number?

If you need to do this in AppleScript (and I have before needed to do just that) the most compact way I know of with this code:

code:

---

set rightNow to current date

set possibleMonths to {January, February, March, April, May, June} &

yeah....I just finished writing that script..... but why would Applescript not let you call the month as an integer in the first place....what a thing to miss.