I'm trying to build a formula for some queries that will update a date field to dates of certain days of the following month. I've uploaded a file called UpdatingDates.zip that can test out various formulas. There are two update queries in the db that when run will update the date fields of the test table. Everything works fine until I change my system date to that of May, and then try to have the queries return the dates in June of this year. Both formulas stumble and don't return the right dates. Anyone have any ideas to improve this?
Russ
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar