Fred in Thailand Posted November 25, 2007 Share Posted November 25, 2007 I have two fields Startdate and endate. They are used to display all records for the current month. A script sets the fields. the start date is a no brainer but I am having a little trouble with calculating the last day of the current month. I have done it for another script that shows the current week with no trouble. Thanks in advance for the help again Link to comment Share on other sites More sharing options...
fabriceN Posted November 25, 2007 Share Posted November 25, 2007 Date ( month ( StartDate ) + 1 ; 0 ; year ( StartDate )) Link to comment Share on other sites More sharing options...
Fred in Thailand Posted November 25, 2007 Author Share Posted November 25, 2007 Thanks Someday I will know all this LOL :jester: Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5998 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 accountSign in
Already have an account? Sign in here.
Sign In Now