BEx Analyzer - getting leading zero for Date field
Hi All,
I have an issue with BEx Analyzer date field.
The requirement is to have date format changed from YYYY/MM/DD to YYYY/M/D for one of the users.
I have tried changing the settings for date format in control Panel in user's system.
The date in Bex changes accordingly but the problem is the user does not get leading zero for date
If it is 8 Oct 2015, she gets 8/10/2015 and not 08/10/2015.
Please suggest how to get the leading zero in place.
I have date with leading 0 in my reports.
Please suggest any ideas you have.
Thank you.
SF