Todays Date

<i><b>Originally posted by : Mike (Mikevb@hotmail.com)</b></i><br />Probably quite simple to most of you, but how to I get "today's date" into <br />a variable for use in an SQL INSERT Statement?<br /><br />Thanks <br /><br />Mike<br />

<i><b>Originally posted by : steve</b></i><br />try<br />strDateTime = Now() gives date and time<br />strDateOnly = Date() gives date only<br /><br />do <br /><br />strsql = strsql & "'" & strDateOnly & "'" <br />this could be used when building your sql string.<br /><br /><br />------------<br />Mike at 4/7/2000 5:41:46 AM<br /><br />Probably quite simple to most of you, but how to I get "today's date" into <br />a variable for use in an SQL INSERT Statement?<br /><br />Thanks <br /><br />Mike<br />