FIRSTOFMONTH(theDate as Date)
Description
Returns a date which is the 1st of the month from theDate
Example
Dim theDate as Date
Dim result as Date
theDate=DateVal(1999,2,15)
result=FirstOfMonth(theDate) 'will calculate result a date of 2/1/1999