I could use a little guidance. I am using calendar month view to display daily data from a SQL query. When the user presses the forward or backward arrows I created, the query populates the calendar with data for that month. When they select a particular day the data for that day is displayed below the calendar for editing. When they press ‘enter’ the data is written back to the database via a SQL update command. It then appears on the calendar within 2 seconds as the query refreshes every 2 seconds.
The problem occurs when the user selects those few days from the previous month or the coming month that make up the first and last week of a month… The selected day then tries to populate my editing field with nonexistent data. How do I keep the selected day within the displayed month?