PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook VBA Programming How to get the current date using VBA

Reply

How to get the current date using VBA

 
Thread Tools Rate Thread
Old 14-11-2005, 01:34 PM   #1
Mody
Guest
 
Posts: n/a
Default How to get the current date using VBA


Hi,
I'm using VBA for Great Plains customization.

I need to get the current date. Is there a function to a way to get the
current date.

Note: I tried to use GETDATE() Function but I got an error message "Sub
or Function not defined".

Regards,
Emad

  Reply With Quote
Old 14-11-2005, 01:41 PM   #2
Rsoutlook.com
Guest
 
Posts: n/a
Default Re: How to get the current date using VBA

You could use now()

--
Ricardo Silva [Outlook MVP]
Add-ins for Microsoft(c) Outlook(c)
http://www.rsoutlook.com/us/products.html


  Reply With Quote
Old 14-11-2005, 02:33 PM   #3
Sue Mosher [MVP-Outlook]
Guest
 
Posts: n/a
Default Re: How to get the current date using VBA

Or Date() if you want just the date, not the time.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Rsoutlook.com" <rsoutlook@discussions.microsoft.com> wrote in message news:eQS2TjR6FHA.3588@TK2MSFTNGP15.phx.gbl...
> You could use now()
>
> --
> Ricardo Silva [Outlook MVP]
> Add-ins for Microsoft(c) Outlook(c)
> http://www.rsoutlook.com/us/products.html
>
>

  Reply With Quote
Old 13-12-2005, 02:28 PM   #4
=?Utf-8?B?16fXldeR16U=?=
Guest
 
Posts: n/a
Default Re: How to get the current date using VBA

and Time() gives you the time.

Yonina.


"Sue Mosher [MVP-Outlook]" wrote:

> Or Date() if you want just the date, not the time.
>
> --
> Sue Mosher, Outlook MVP
> Author of Configuring Microsoft Outlook 2003
> http://www.turtleflock.com/olconfig/index.htm
> and Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Rsoutlook.com" <rsoutlook@discussions.microsoft.com> wrote in message news:eQS2TjR6FHA.3588@TK2MSFTNGP15.phx.gbl...
> > You could use now()
> >
> > --
> > Ricardo Silva [Outlook MVP]
> > Add-ins for Microsoft(c) Outlook(c)
> > http://www.rsoutlook.com/us/products.html
> >
> >

>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off