First day of month

[defectivo]

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.

[Raybaudi]

Yes, you are right !

The calc is:

Case(

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

""

)

[defectivo]

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

[Lee Smith]

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, 2005 by Guest
add mod calc

[comment]

In version 5, use comma instead of semicolon.

You can also simplify the formula to:

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

[Raybaudi]

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

[defectivo]

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: