Guest_imported
New member
- Jan 1, 1970
- 0
Is there any function in VFP that returns the last date of the month. <p>Narjes<br><a href=mailto:njamal@bahrainstock.com>njamal@bahrainstock.com</a><br><a href= > </a><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Last date of a month 2
- Thread starter Guest_imported
- Start date
- Status
-
2
- #2
Hi Narjes,<br><br>To return the last day of the current month:<br>gomonth(date() - day(date()) + 1, 1) - 1<br><br>To return the last day of lnMonth in lnYear:<br>gomonth(date(lnYear, lnMonth, 1), 1) - 1<br><br>Enjoy!<br> <p>Jon<br><a href=mailto: > </a><br><a href= > </a><br>Carpe Diem!
- Status
Similar threads
- Question