MySQL will be run on a local server (a PC) and there may be times when a user might not know that the machine date had been accidentally changed, so the insertion date can be future or past . Is there any ways to solve this problem..

The server should not allow the times to change and times should be kept in sync with a time server client (on Linux ntp service). You should disable allowing anyone to modify the date/time on the server.