Ron Rosenfeld wrote:

EOMONTH() is equivalent to DATE(YEAR(NOW()),MONTH(NOW())+1,1)-1

or, more simply:

DATE(YEAR(NOW()),MONTH(NOW()),0)

Shouldn't that read

DATE(YEAR(NOW()),MONTH(NOW())+1,0) ?


--
Gordon Rainsford

London UK