date serial
 

How do I get today's date as a serial into a variable?

dim dDate as Date
dDate = serial NOW()

Of course the above does not work.

date serial
 

try:

Sub aa()
Dim serdate As Long
serdate = DateValue(Now)
End Sub

date serial
 

dim lDate as long
ldate = clng(date)



Striker wrote:

How do I get today's date as a serial into a variable?

dim dDate as Date
dDate = serial NOW()

Of course the above does not work.

--

Dave Peterson