I have an interesting problem I hope someone can help with.
I was testing/developing a view with date based calculations and decided to change my computer system date into the future to test the functionality.
During this period I updated a few documents in the database I was testing and then later reset my system date back to present. However now the "Last modified" date is stuck at this future date.
Also, worse, every document I update on this database shows a last modified date of this future date. Every other date function seems to pick up the current system date ok.
The database in question is a local replica. The server copy shows a correct last modified date thankfully.
I have checked other local replicas on my PC and only this one database appears to be affected.
Question: is there any way to fix this date? or do I have to wait until the date actually comes around before it begins to update correctly?!