month as a number

[pug]

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

[esteshk]

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 ]

[pug]

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.

[dspires]

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

[Chuck]

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} &

[pug]

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.