in does not support text and date measures Smart View does. The number you are seeing is the number of seconds since Jan1.1970 which is how Essbase internally stores dates. I also don't think you will be able to get the value o the UDA to use in a calculation. you might need to create another measure Monthend date that you populate with the date you want to calculate from.
Retrieve it in Smart View and see if it is working? Sure you uploaded 7/31/1996 that number is the equivalent for 7/30/1996.
Essbase is setting the right value (the number you see there is called as Epoch time). It should be working fine. Did you try just the @DATEPART first?
@DatePart("Store Open Date",DP_MONTH);
EDIT: You beat me (Smart View) GlennS_3
Thank you for the information. Unfortunately I am unable to install Smart View, the installation seems to run but I do not have SmartView in the Excel menu bar. (Whole different issue I will have to trouble shoot.)
For this issue... Does FR support date measures?
I guess it does, I can pull the Store Open Date into FR but the members with the @Date... formula show #MISSING. Any ideas?