Hi everybody,

I have a scheduling database for my school guidance office. At the momment, it has no calendar feature...yet. In the meantime, I have a giant list of dates all in the system that users just click on.

However, this list is extremely large and I need a way to mark the first day of a month (there are entries for each schoolday of the month in the system).

Is it possible to do a calculattion that looks at my field called Date. I think I need an if statments that says if the Date is equal to the first day of the month, write whatever that month's name is.

Any thoughts...I'm so lost.

Yes, you are right !

The calc is:

Case(

date = Date( Month(date) ; 1 ; Year(date ));MonthName( date );

""

)

Thanks for your amazing help it truly made my day...but I coppied and pasted it into the calc window...and it says there is an error and it selects this part of the calc .....; 1 ; Year.....

I'm too inexperienced with calcs to figure that one out

In Version 5, you need to have commas, and not Semi-colons. So just Replace the ; with , and see if that doesn't do it.

Case(

date = Date( Month(date) , 1 , Year(date )),MonthName( date ),

""

)

Lee

Edited December 7, 200520 yr by Guest
add mod calc

In version 5, use comma instead of semicolon.

You can also simplify the formula to:

Case ( Day ( date ) = 1 , MonthName ( date ) )

Yes, Italian version needed semicolons, but English version need commas

Hi Everybody,

You are truly AMAZING...I've added the feature now to my databse with no problem and I'm just blown away with it's power now -- all becuse of you :smirk: