|
|
Working with Dates and TimeRead the article this discussion is about
This archived discussion is "read only".
» mdehnel - Date and Time Combined Is there a proper way to combine date and timeIf I have strings for I get and error when I try -- posted by mdehnel » kmaxim - Re: Date and Time Combined In response to message posted by mdehnel:Thank you for your question. You can combine date and time in one string using string concatenation (&). Consider the following example:
In your example, CDate(08/23/2001 1:20:00 AM) Script engine can not recognize argument as the date and time literals. You should code it using quotation marks " or better pound sign # (recomended by Microsoft). Try the following: CDate("08/23/2001 1:20:00 AM") or CDate(#08/23/2001 1:20:00 AM#). -- posted by kmaxim » akidi - OUTLOOK APPLICATION USING VBSCRIPT Hello All,Please Could anybody help me with this : I have this Outlook 2000 application development problems which I dont know how to begin with as even though I've been programming with other languages I've never done that with outlook using VBScripting. I saw u people's contribution to SUITE101 website.I am doing my final thesis on this and any asistance rendered will be highly appreciated, here are the specifications: > > Specification (draft) > > Functions: > 1) > To calculate a running total of flexible working hours and show it in calendar view based on a reference calendar which is on server in "Public Folders" with a name "Standard Working Hours" > > A separate "balance ticket" can be generated as well and user may open the balance ticket to get all the required information (daily and running balance). > > Another option is to place the information in the "Tasks" folder of the user or some other special "Own Working Hours" > > 2) > To calculate own daily working hours based on a reference calendar which is on server in "Public Folders" with a name "Working Hours" > > 3) > To check that there are no overlapping hours (overlapping appointments are OK, but the ones starting with an integer are not permitted to overlap). A RED error ticket may be generated or some other form of error message should be displayed to the user in error condition. > > 4) > TO make a balance correction - if needed based on special "balance correction" appoinment on the day given for the future days > > 5) > To produce a (given time span) report of used working hours to specific codenumber or task. This is extra bonus feature. > > Tools: > 1) Outlook-2000 + forms > 2) visual basic > Thankx for your anticipated assistance. -- posted by akidi
Please follow the guidelines set forth in the Suite101 Posting Etiquette when adding to the discussion. |
|
|
|
|
|
|
|