How to get the current date using VBA

's Computer Specifications

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

's Computer Specifications

You could use now()

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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> You could use now()
>
> --
> Ricardo Silva [Outlook MVP]
> Add-ins for Microsoft(c) Outlook(c)
> http://www.rsoutlook.com/us/products.html
>
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> > You could use now()
> >
> > --
> > Ricardo Silva [Outlook MVP]
> > Add-ins for Microsoft(c) Outlook(c)
> > http://www.rsoutlook.com/us/products.html
> >
> >
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date changes from the desired date to current date when printing	gsf1	Microsoft Word Document Management	1	9th Apr 2009 07:49 PM
Can I automatically enter the current date or current time into a	=?Utf-8?B?QmVu?=	Microsoft Excel New Users	7	19th Oct 2005 04:38 PM
Calculate date difference between fixed date and current date	Dave Elliott	Microsoft Access Forms	3	23rd May 2005 04:54 AM
date difference using current date is no date is entered	=?Utf-8?B?QmV0c3lL?=	Microsoft Access Queries	5	7th Apr 2005 05:53 PM
current date & time & current user	=?Utf-8?B?Sm93ZW4=?=	Microsoft Access	1	5th Feb 2005 08:25 PM