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?!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!