i format it as this

Format(month(date),"mm/dd/yyyy")

isn't it right?

Actually,my problem is this..

Currently the Start Date defaults to the first day of the current
month.
The request is to default the start date to the first day of the
quarter
(e.g. 01.01, 04.01,07.01,10.01... +year).

If the current month is between 1 and 3, default is 01.01.+current
year
If the current month is between 4 and 6, default is 04.01.+current
year

Please kindly guide.


--
anu_manu
------------------------------------------------------------------------
anu_manu's Profile: http://www.excelforum.com/member.php...o&userid=31510
View this thread: http://www.excelforum.com/showthread...hreadid=516246