mooSysDate()


Returns the value of SysDate within the Oracle OLAP environment.


Syntax


               mooSysDate()


Return Value


               STRING


Example


Public Sub mooSysTimeStampANDmooSysDate()

'Shows the value of SysTimeStamp and sysDate


Dim boo As Boolean


If Not oregistered Then:   boo = regQ:


'Check Im connected if not connect

If Not o.connected Then

   boo = o.connect

   boo = o.connected

   Else

   boo = True

End If


'Connected so execute

If boo = True Then

     Debug.Print o.mooSysTimeStamp()  

     'returns ie. 11-MAY-10 17.58.17.851963 +01:00

     Debug.Print o.mooSysDate()      

     'returns ie. 11-MAY-10

     

    Else

   'Something went wrong print any error information

   Debug.Print "Unable to Connect"

   Debug.Print o.getlastmooerr

End If

End Sub