Hi Mits,
Thanks for the response.
In my case I was able to change the Creation Date and Modification Date properties of Document by disabling the Auditable aspect. I am also able to see these being reflected in Alfresco explorer application.
The problem is when I use CMIS api to retrieve the document, it doesn't return the Creation Date and Modification Date as seen in Alfresco explorer application.
Yes, using the Custom Aspect would be my last option to resolve this issue. However I am unable to find why the CMIS api doesn't return the same dates as that of the Alfresco explorer web application.