Having a date issue in a query
Got a odd issue. What I'm trying to accomplish is to have the user enter the date from what's printed from the text column PaySchedule in this example every 15th. They would enter whatever date the Payment Date was i.e. 1/6/2022. Then it would subtract the date they paid from the due date, the PayScheduleDate column. For whatever reason it's not giving the correct numbers. If I subtract 6 days from the Payment Date it should be 0 days but it's showing 31. I tried adding 1 to the query and that didn't work either. Not sure what the issue is. I formatted the DateStatus field to only show "dd" not sure if that has anything to do with the issue. I'm stuck. Let me know if anyone has any suggestions for this.
