Ask a master datetimepicker

garfield5d

In a management system, I use two datetimepicker controls to indicate the starting year and month and ending year and month of the rent paid. The style is set to up and down arrow, and the format is set to display only the year and month, because there is no 30 in February. And on the 31st, when the current date is 30 or 31, an error occurs when the month is changed to 2. A friend helped me solve this problem in the post, that is, first set datetimepicker2.date:=startofthemonth(now), now Encountered a new problem: when entering the time into the database, you need to set the date of datetimepicker2 to the last day of the month. Otherwise, when the query condition is time, the query will be one month less. I tried to write such code in the onExit event of the datetimepicker: datetimepicker2.date:=endofthemonth(datetimepicker2.date), but it didn't work at all. Which hero can help me solve it.

面面爱面面

Why do you have to enter it manually? How good is automatic? The dateutils unit and sysutils unit have many functions for calculation.

athena815

You can change the format property in the DateTimePicker control to'yyyy-MM', and note that the month should be capitalized so that the year and month are selected.

Use the following statement when warehousing, so that the returned string is the date of the last day of each month
FormatDateTime('yyyy-mm',DateTimePicker1.DateTime)+'-'+IntToStr(DaysInMonth(DateTimePicker1.DateTime))