in my expression this works fine:
=DatePart("d",DateAdd("ww", -3,Now()) )
but when I add:
="Day:"+DatePart("d",DateAdd("ww", -3,Now()) )
I get an error saying:
The value expression for the textbox 'textbox10' contains an error: Input
string was not in a correct format.Try this:
="Day:"&DatePart("d",DateAdd("ww", -3,Now()).toshortdatestring)
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:eEwgMhcbEHA.3420@.TK2MSFTNGP12.phx.gbl...
> in my expression this works fine:
> =DatePart("d",DateAdd("ww", -3,Now()) )
> but when I add:
> ="Day:"+DatePart("d",DateAdd("ww", -3,Now()) )
> I get an error saying:
> The value expression for the textbox 'textbox10' contains an error: Input
> string was not in a correct format.
>|||DatePart returns an integer. To concatenate with a string try one of these
two expressions:
="Day:" & DatePart("d",DateAdd("ww", -3,Now()) )
="Day:" + CStr(DatePart("d",DateAdd("ww", -3,Now()) ))
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:eEwgMhcbEHA.3420@.TK2MSFTNGP12.phx.gbl...
> in my expression this works fine:
> =DatePart("d",DateAdd("ww", -3,Now()) )
> but when I add:
> ="Day:"+DatePart("d",DateAdd("ww", -3,Now()) )
> I get an error saying:
> The value expression for the textbox 'textbox10' contains an error: Input
> string was not in a correct format.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment