cesaros Posted March 30, 2011 Report Share Posted March 30, 2011 Hi is my first time in the forum, if you need help with macro express can know which is the last day of the month, that making a macro that generates reports per month and up 3 months ago, starting from day 1 to the last day of the month Thank´s Quote Link to comment Share on other sites More sharing options...
acantor Posted March 30, 2011 Report Share Posted March 30, 2011 To determine whether today is the last day of the month, you need a macro something like this (in pseudo-code): // %T1% is today's month in <num><num> format, e.g., February = 02 // %T2% is the number of days in the month Today's month = %T1% // If January, March, May, etc. If %T1% = "01" OR %T1% = "03" %T1% = "05" etc. %T2% = "31" // If April, June, etc. If %T1% = "04" OR %T1% = "06" etc. %T2% = "30" // Else it's February. (Need a special case for leap years) Else %T2% = "28" Quote Link to comment Share on other sites More sharing options...
cesaros Posted March 31, 2011 Author Report Share Posted March 31, 2011 Thanks, I had to make some sort of function that returns me the total number of days per month Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.