StartDate

[HeleneB]

I am creating a simple appointment export to excel. How do I extract just the appointment start time from the StartDate field and conversely, how do I extract just the date from the StartDate field.

Many thanks
Helene

Topic

[Support 3]

See the Visual Basic Scripting Guide which provides various Date functions. You can access the guide from GroupWise – Help – Formativ Help menu or from Formativ IDE – Help menu.

Sample code below uses FormatDateTime() funstion to access date & time, also uses Year(), Month(), etc function to extract part of the date.

  
  msgbox FormatDateTime(iStartDate, vbShortDate)
  msgbox FormatDateTime(iStartDate, vbShortTime)


  msgbox "Year: " & Year(iStartDate) & ", Month: " & Month(iStartDate) &_
  ", Day: " & Day(iStartDate) & ", Hour: " & Hour(iStartDate) &_
  ", Minute: " & Minute(iStartDate) & ", Second: " & Second(iStartDate)

Regards,
Advansys Support

[Author]

Replies