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 (3) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar