Fomat (Date, yymmdd) function...

Hi I have the following code that names a file with a prefix and then the
date. I need the date to be - 1 day. Can anyone help?

sFilename = "CNLOPB " & Format(Date, "d-mmmm-yy")

Thanks,
Cathy

Hi Cathy,

sFilename = "CNLOPB " & Format(Date - 1, "d-mmmm-yy")


--
Kind regards,

Niek Otten

"Cathy W" <CathyW@discussions.microsoft.com> wrote in message
news:C1869884-BF65-4EE8-BD54-E49F4F4ED29D@microsoft.com...
> Hi I have the following code that names a file with a prefix and then the
> date. I need the date to be - 1 day. Can anyone help?
>
> sFilename = "CNLOPB " & Format(Date, "d-mmmm-yy")
>
> Thanks,
> Cathy

Thanks,

Cathy

"Niek Otten" wrote:

> Hi Cathy,
>
> sFilename = "CNLOPB " & Format(Date - 1, "d-mmmm-yy")
>
>
> --
> Kind regards,
>
> Niek Otten
>
> "Cathy W" <CathyW@discussions.microsoft.com> wrote in message
> news:C1869884-BF65-4EE8-BD54-E49F4F4ED29D@microsoft.com...
> > Hi I have the following code that names a file with a prefix and then the
> > date. I need the date to be - 1 day. Can anyone help?
> >
> > sFilename = "CNLOPB " & Format(Date, "d-mmmm-yy")
> >
> > Thanks,
> > Cathy
>
>
>