Hi Thembelani,

              First we  convert date to horolog.

             set p="12/03/2019"

            set horval=$zdateh(p)  //now we got horolog value is 65350

         After that , we use $zdate function and convert the date format.

          w $zdate(horval,3) // now we got 2019-12-03


Ponnumani G

DeepSee has a Developer Tutorial in the Documentation. This Is very good . Some example available for this Document .For Ex."HoleFoods" and "Patients" cubes in the SAMPLES namespace .