I tested it again, now even with Date property if I input 31/5/2018 it makes it 30/5/2018. Whatever date I input it goes to one day back.
Use @TODATE Function for date1 and date2
If this is for planning then why not use one of the calc manager functions like which have been specifically designed for this, more info - Date/Time Functions
For example using @CalcMgrDaysBetween
Another example - @CalcMgrDaysBetween function in PBCS Test Environment not working
Also I am not sure why you would want to keep changing a member from a date property to unspecified but I tested in planning 126.96.36.199.007 and it didn't set the date back a day.
Date date type
Changed to unspecified data type
Thanks John and Avinash,
I will check it update. I'm using 188.8.131.52.0.79
I was just checking how it stores the date in Essbase because I was doing something based on days and was facing issue. I hope you would have seen video too. It never happened before even with me.
It should store as YYYYMMDD, you can see from my example I am not seeing any issues.
I would recommend patching planning if you are still on the base release, there have been lots of fixes, I am not saying it would resolve your issue but it is definitely time you consider patching your environment.