DateSerial Format

[venu_resoju]

Hai Friends..



I am trying to form a Format of DateSerial function, but I am unable to get succeed.

I want the format for the first day of the month in the following structure:
01-Jan-2013
&
the last day of the last month(not current month) in the following structure : 31-Dce-2012

Please help me for the above

Thanking you.

[ssanfu]

First of the current month

DateSerial(Year(Date()),Month(Date()),1)

#1/1/2013#


Last day of last month

DateSerial(Year(Date), Month(Date), 0)

#12/31/2012#


To change the way it is displayed =>> Format(#1/1/2013#,"dd-mmm-yyyy")
returns 01-Jan-2013

Format(#12/31/2012#,"dd-mmm-yyyy")
returns 31-Dec-2012

That is the best I can do - you didn't provide VBA code or query (SQL) or say how you want to use DateSerial() or Format() functions.

[venu_resoju]

Thank you ssanfu,

I am trying like below for a text box...

=Formate([DateSerial(Year(Now), Month(Now), 1)], "DD-MMM-YYYY")

&
=Formate([DateSerial(Year(Now), Month(Now), 0)], "DD-MMM-YYYY")

but I didn't get

thanking you

[ssanfu]

=Formate([DateSerial(Year(Now), Month(Now), 1)], "DD-MMM-YYYY")

Format does not have a "E".

=Format(DateSerial(Year(Date), Month(Date), 0),"dd-mmm-yyyy")

[venu_resoju]

THANK YOU ssanfu....