Date Parameter Default format

Hi,
I would like the default format ("Default values/Non-queried") of a date
parameter to bein the format of: 20-Aug-2004. I have made the parameter a
string type and used: =day(now) & "-" & month(now) & "-" & year(now) but it
return 20-8-2004. What can I do to format the "08" to "Aug".
Thank you in advance.You could use
=day(now) & "-" & MonthName(month(now),True) & "-" & year(now)
"Johan" wrote:
> Hi,
> I would like the default format ("Default values/Non-queried") of a date
> parameter to bein the format of: 20-Aug-2004. I have made the parameter a
> string type and used: =day(now) & "-" & month(now) & "-" & year(now) but it
> return 20-8-2004. What can I do to format the "08" to "Aug".
> Thank you in advance.
>|||Brilliant! Thanks, it works. Where did you look this up and what code is used
here (C#?)
"Sangfroid" wrote:
> You could use
> =day(now) & "-" & MonthName(month(now),True) & "-" & year(now)
> "Johan" wrote:
> > Hi,
> >
> > I would like the default format ("Default values/Non-queried") of a date
> > parameter to bein the format of: 20-Aug-2004. I have made the parameter a
> > string type and used: =day(now) & "-" & month(now) & "-" & year(now) but it
> > return 20-8-2004. What can I do to format the "08" to "Aug".
> >
> > Thank you in advance.
> >|||It is VB code.
Whatever you write in the Expressions tab for any control is basically VB
code.
Go through this link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctiif.asp
"Johan" wrote:
> Brilliant! Thanks, it works. Where did you look this up and what code is used
> here (C#?)
> "Sangfroid" wrote:
> > You could use
> > =day(now) & "-" & MonthName(month(now),True) & "-" & year(now)
> >
> > "Johan" wrote:
> >
> > > Hi,
> > >
> > > I would like the default format ("Default values/Non-queried") of a date
> > > parameter to bein the format of: 20-Aug-2004. I have made the parameter a
> > > string type and used: =day(now) & "-" & month(now) & "-" & year(now) but it
> > > return 20-8-2004. What can I do to format the "08" to "Aug".
> > >
> > > Thank you in advance.
> > >|||Thanks Ravi!
"Ravi" wrote:
> It is VB code.
> Whatever you write in the Expressions tab for any control is basically VB
> code.
> Go through this link
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctiif.asp
>
> "Johan" wrote:
> > Brilliant! Thanks, it works. Where did you look this up and what code is used
> > here (C#?)
> >
> > "Sangfroid" wrote:
> >
> > > You could use
> > > =day(now) & "-" & MonthName(month(now),True) & "-" & year(now)
> > >
> > > "Johan" wrote:
> > >
> > > > Hi,
> > > >
> > > > I would like the default format ("Default values/Non-queried") of a date
> > > > parameter to bein the format of: 20-Aug-2004. I have made the parameter a
> > > > string type and used: =day(now) & "-" & month(now) & "-" & year(now) but it
> > > > return 20-8-2004. What can I do to format the "08" to "Aug".
> > > >
> > > > Thank you in advance.
> > > >|||Hello.
I have a question about the same thing I think. What is the write way to
write the expression below.
=Datename(Month( Fields!AVG_MONTHLY1_BAL.Value ))
Any help would be appreciated.
Thank you.
"Johan" wrote:
> Thanks Ravi!
> "Ravi" wrote:
> > It is VB code.
> > Whatever you write in the Expressions tab for any control is basically VB
> > code.
> > Go through this link
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctiif.asp
> >
> >
> > "Johan" wrote:
> >
> > > Brilliant! Thanks, it works. Where did you look this up and what code is used
> > > here (C#?)
> > >
> > > "Sangfroid" wrote:
> > >
> > > > You could use
> > > > =day(now) & "-" & MonthName(month(now),True) & "-" & year(now)
> > > >
> > > > "Johan" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I would like the default format ("Default values/Non-queried") of a date
> > > > > parameter to bein the format of: 20-Aug-2004. I have made the parameter a
> > > > > string type and used: =day(now) & "-" & month(now) & "-" & year(now) but it
> > > > > return 20-8-2004. What can I do to format the "08" to "Aug".
> > > > >
> > > > > Thank you in advance.
> > > > >|||Problem fixed. Thak you
"wilerwin" wrote:
> Hello.
> I have a question about the same thing I think. What is the write way to
> write the expression below.
> =Datename(Month( Fields!AVG_MONTHLY1_BAL.Value ))
> Any help would be appreciated.
> Thank you.
> "Johan" wrote:
> > Thanks Ravi!
> >
> > "Ravi" wrote:
> >
> > > It is VB code.
> > > Whatever you write in the Expressions tab for any control is basically VB
> > > code.
> > > Go through this link
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctiif.asp
> > >
> > >
> > > "Johan" wrote:
> > >
> > > > Brilliant! Thanks, it works. Where did you look this up and what code is used
> > > > here (C#?)
> > > >
> > > > "Sangfroid" wrote:
> > > >
> > > > > You could use
> > > > > =day(now) & "-" & MonthName(month(now),True) & "-" & year(now)
> > > > >
> > > > > "Johan" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I would like the default format ("Default values/Non-queried") of a date
> > > > > > parameter to bein the format of: 20-Aug-2004. I have made the parameter a
> > > > > > string type and used: =day(now) & "-" & month(now) & "-" & year(now) but it
> > > > > > return 20-8-2004. What can I do to format the "08" to "Aug".
> > > > > >
> > > > > > Thank you in advance.
> > > > > >