Friday, February 24, 2012

format Date

Hi,
How do I format dateme to i.e. Thursday, February 17,2005? Thanks.
ChuckFomat(datefield,"D")
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:BD88F7E7-8BF8-478A-A8A9-B8750A1284A8@.microsoft.com...
> Hi,
> How do I format dateme to i.e. Thursday, February 17,2005? Thanks.
>
> Chuck|||Hi Jessica,
Thanks for your prompt reply. When I format it as
="Date: " & Fomat(datetime.today,"D") in a text box, I got an error saying
'Name 'Format' is not declared'. Any way to solve it? Thanks again.
"Jessica C" wrote:
> Fomat(datefield,"D")
> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
> news:BD88F7E7-8BF8-478A-A8A9-B8750A1284A8@.microsoft.com...
> > Hi,
> >
> > How do I format dateme to i.e. Thursday, February 17,2005? Thanks.
> >
> >
> > Chuck
>
>|||Format with an "r"
Mike G.
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:DE3CC541-15D8-463A-BB54-D4119D7D6199@.microsoft.com...
> Hi Jessica,
> Thanks for your prompt reply. When I format it as
> ="Date: " & Fomat(datetime.today,"D") in a text box, I got an error saying
> 'Name 'Format' is not declared'. Any way to solve it? Thanks again.
>
> "Jessica C" wrote:
>> Fomat(datefield,"D")
>> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
>> news:BD88F7E7-8BF8-478A-A8A9-B8750A1284A8@.microsoft.com...
>> > Hi,
>> >
>> > How do I format dateme to i.e. Thursday, February 17,2005? Thanks.
>> >
>> >
>> > Chuck
>>|||You need to use VBScript functions in Report Designer.
Try:
="Date: " & FormatDateTime(datetime.today, 2)
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:DE3CC541-15D8-463A-BB54-D4119D7D6199@.microsoft.com...
> Hi Jessica,
> Thanks for your prompt reply. When I format it as
> ="Date: " & Fomat(datetime.today,"D") in a text box, I got an error saying
> 'Name 'Format' is not declared'. Any way to solve it? Thanks again.
>
> "Jessica C" wrote:
> > Fomat(datefield,"D")
> >
> > "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
> > news:BD88F7E7-8BF8-478A-A8A9-B8750A1284A8@.microsoft.com...
> > > Hi,
> > >
> > > How do I format dateme to i.e. Thursday, February 17,2005? Thanks.
> > >
> > >
> > > Chuck
> >
> >
> >

No comments:

Post a Comment