Jump to content

First day of month


This topic is 5772 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by Guest
add mod calc
Link to comment
Share on other sites

This topic is 5772 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.