Date Time Questions

[Greg Smith]

Can someone tell me or point me to a link that shows the
correct commands to use in Outlook that deals with the
dates and time? I am after the commands to give me just
the date. Not the date and time. I am looking for
something to give me just the current month, current day,
current year.

EX: NOW gives the date and time. I just need the date.

Thanks, Greg

 

[Ken Slovak - [MVP - Outlook]]

Try using the Date function. That doesn't return the time.

Open the Outlook VBA project and type Date in a code module then press
F1. That will give you help on the Date function and See Also in the
help will link to other date/time functions.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm

 

[Greg Smith]

Learned something new today. That did the trick!! Thanks.
One other thing, I can now get the date diff from 2 dates.

How can I tell it to ignore weekends? I want the date diff
from Monday through Friday only??

-----Original Message-----
Try using the Date function. That doesn't return the time.

Open the Outlook VBA project and type Date in a code module then press
F1. That will give you help on the Date function and See Also in the
help will link to other date/time functions.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm

Can someone tell me or point me to a link that shows the
correct commands to use in Outlook that deals with the
dates and time? I am after the commands to give me just
the date. Not the date and time. I am looking for
something to give me just the current month, current day,
current year.

EX: NOW gives the date and time. I just need the date.

Thanks, Greg

.

 

[Ken Slovak - [MVP - Outlook]]

As I said, the Object Browser is your friend. Use "w" for weekday for
the interval argument in the DateDiff function.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm