Is there a today() function in VBA?

Hot Topic

creating UTF-8 file in Excel Macro
How can I modify the "Available References" list from VBA?
Copy text from textbox to clipboard?
Count and display in cell
command button issue
connection to foxpro datasource from excel vba
VBA Excel - Using The "For each" function with a string
Assign an array to .values and .Xvalues in an excel chart
Save Workbook code works fine in Win2000, however given an error in XP
Autofilter criteria's

Microsoft ISV

Command Buttons (Delete, Run, and Close)
How to change line within one statement?
MergeSort for Double Arrays
VBA function having it's name's case changed in excel
Userform Controls
Microsoft SQL Server Runtime License details needed
Highlight Row depending on cell - Excel VBA -
MS Office document and image writer print driver
precisely position embedded charts in worksheet
Place a CR in normal Text Box via vba

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?

  • Rick Penner

    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.

  • Amir.S

    You can use "MyDate = Date()" for that. (^_^ ) If you want to the current time, use "MyTime = Time()"

  • Ggreg

    i use now() to enter the date for new entries into my database - i would assume that it also works for excel
  • Is there a today() function in VBA?
Answer this question