In a previous CEAL blog, we have discussed
how to calculate dates in Planning/PBCS:
As discussed in that blog, for dates in
Planning/PBCS, Essbase stores the date as a numerical value e.g. a Start Date
of 21st May 2015 would be stored as 20150521.
In a non-Planning/PBCS Essbase database,
date functionality exists using the number of seconds elapsed since midnight,
January 1, 1970 i.e. a non-numerical format different to the way Planning/PBCS stores
dates to display on web forms.
is possible, however, to use the Essbase date format and then convert that date
into a Planning/PBCS format for use on a web form in order to populate a Planning/PBCS
date member with today’s date i.e. the system date.