yuccakid
05-29-2000, 06:03 PM
I have a form that shows from and through dates. The from date is a fixed date - "Patient admission date" through "the last day of the previous month" previous to the "current" date. My current DateSerial function is =DateSerial(2000,5,1-1). Can I automatically update the "month" and "year"?
R. Hicks
05-29-2000, 07:14 PM
I assume you wish to use the current Month and Year from the computer's current date. If this is true, try this:
=DateSerial(Year(Now()),Month(Now()),1-1)
HTH
RDH
yuccakid
05-29-2000, 07:25 PM
Thanks very much. The online help showed DateSerial Function would only work with "numeric" input (year "2000", Month "5") and so on. It works perfectly.