----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: QuiteSmallwonder1984 Message 12 in Discussion hi U can use convert() function in your queries for getting the datE time in the format desired by you. Syntax is convert(varchar,date,option) where date is the variable which is containing date option can be 111,104,108,110 and so on find in net the option values and their corresponding results. >From: "Sudha0829" <[EMAIL PROTECTED]> >Reply-To: "BDOTNET" <[email protected]> >To: BDOTNET <[email protected]> >Subject: Re: SQL Server Reporting Services DateTime Parameter Formatting >Date: Thu, 29 Dec 2005 18:51:41 -0800 > > > > > > > > > > > > > New Message on BDOTNET > > > > > > > > SQL Server Reporting Services DateTime Parameter Formatting > > > > > Reply > > > > > > Reply to Sender > Recommend > > Message 10 in Discussion > > > > > > > > From: > Sudha0829 > > > > > > > > > > New Message on BDOTNET > > > > > > > > SQL Server Reporting Services DateTime Parameter Formatting > > > > > Reply > > > > > > Reply to Sender > Recommend > > Message 2 in Discussion > > > > > > > > From: > Sudha0829 > > > > > Hi, r u useing crystal reports? regards, Sudha. > >Sara <[EMAIL PROTECTED]> wrote: New Message on BDOTNET > SQL Server Reporting Services DateTime Parameter Formatting > > Reply > Reply to Sender Recommend Message 1 in Discussion > From: Sara > Hi, > We are using SQL Server Reporting Services 2005 for our reports. We are >facing the problem currently the parameter input box for a datetime type >takes the values in the MM/DD/YYYY format. Is it possible to change this to >MM/DD/YYYY? we want to remove the 12:00 AM time from the input box aslo > >Thanks in Advance Saravanan >View other groups in this category. > > > > > Yahoo! Photos > >Ring in the New Year with Photo Calendars. Add photos, events, holidays, >whatever. > > > > > > > View other groups in this category. > > > > > > > > > > > > > > > View other groups in this category. > > > > > > > > > > > > > >Also on MSN: >Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily >Horoscopes > > > > > > > > > > > To stop getting this e-mail, or change how often it >arrives, go to your E-mail Settings. > > > Need help? If you've forgotten your password, > please go >to Passport Member Services. > > For other questions or feedback, go to our > Contact Us >page. > > > If you do not want to receive future e-mail > from this >MSN group, or if you received this message by mistake, please click the >"Remove" link below. On the pre-addressed e-mail message that opens, simply >click "Send". Your e-mail address will be deleted from this group's mailing >list. > > > Remove my e-mail address from BDOTNET. > > > > > > > _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
