Is there a today() function in VBA?

Hot Topic

Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional
HTTP request - simple problem
DLookup help?
Automatically send attachment in email with a submit command button in word
military sites
Reading PDF files from VBA
Unbale To Read File
Disable Shift Key Before Startup
IIF Statement
Dynamick picklist in MS CRM 3.0

Microsoft ISV

Closing desktop opened word wants to close embedded word object
Hide/unhide
Can you use VBA to access a spread sheet embedded in a word doc?
hi duck thing . could u help me ( [Excel] How to convert Excel to jpg, gif image?)
Save document as web page
sending emails from MS Word with variable subject line
Share my JMC_Photo_View 2.1
[Excel] How to convert Excel to jpg, gif image?
DLookup help?
variable declarations

Is there a today() function in VBA?

I've been trying to get the current date a few ways in VBA. I tried using the today() function in a spreadsheet and getting the data from that cell and also calling it explicitly in a vba script and have had no success. any help will be appreciated.


Answer this question

Is there a today() function in VBA?

  • goozbee

    i use now() to enter the date for new entries into my database - i would assume that it also works for excel

  • gbrot

    Offcourse. (^_^ ) The only difference between Now and the one's i've suggested is that Now contains both the current date and time while Date and Time are seperate commands for the date and time. (^_^ ) It all depends on which information you need.

  • matti-81

    You can use "MyDate = Date()" for that. (^_^ ) If you want to the current time, use "MyTime = Time()"
  • Is there a today() function in VBA?
Answer this question