Thank you, Joe, for your prompt response. You solve my problem in a nick of time. Once again, thanks.
Regards, jay
--- In AccessDevelopers@yahoogroups.com, "joe010677" wrote:
>
> Sorry, Jay,
>
> I didn't address your formatting issue. give this a try:
>
> ="Report for month ending " & Format(DateSerial(Year(Date()),Month(Date())+1,0),"dd mmm yyyy")
>
> Regards,
>
> Joe
>
> --- In AccessDevelopers@yahoogroups.com, "joe010677" wrote:
> >
> >
> >
> > try this
> >
> > ="Report for month ending " & DateSerial(Year(Date()),Month(Date())+1,0)
> >
> > Regards,
> >
> > Joe
> >
> > --- In AccessDevelopers@yahoogroups.com, "Jay" wrote:
> > >
> > > I prepare a report for each month. My title is "Report for month ending 2012/12/31"
> > >
> > > I have been using the following codes on the report header
> > > = "Report for month ending " & DateSerial(Year(Date()),Month(Date()),0)
> > >
> > > This code works fine last year. Today when I was trying to prepare the Jan 2013 report, it still continue to show 2012/12/31 instead of 2013/1/31.
> > >
> > > Can anyone highlight the problem to me? Can I rearrange to 31 Jan 2013 instead of the yy/mm/dd format?
> > >
> > > Your assistance will be much appreciated.
> > >
> > > Regards, jay
> > >
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar