Thanks Jeff, that is exactly what I was looking for.
Christopher Bodnar Enterprise Architect I, Corporate Office of Technology:Enterprise Architecture and Engineering Services Tel 610-807-6459 3900 Burgess Place, Bethlehem, PA 18017 [email protected] The Guardian Life Insurance Company of America www.guardianlife.com From: Jeff Steward <[email protected]> To: "NT System Admin Issues" <[email protected]> Date: 11/01/2012 07:47 PM Subject: Re: OT: SSRS question Right click the text box in which you are displaying the date/time field. Select Text Box Properties. Click Number. Chose Date from the Category. Select the format type you want. Alternatively, type a lowercase d in the Format property of the Text Box to get a mm/dd/yyyy display. -Jeff On Thu, Nov 1, 2012 at 3:32 PM, Christopher Bodnar < [email protected]> wrote: Any SSRS guys out there that might be able to help me with this? It's 2008 R2. Creating a report that uses a log file as the data source. Using an OLEDB connection string and a SCHEMA.INI file to set a custom delimiter: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\10.x.x.x\Data\;Extended Properties="text;HDR=Yes;Format=Delimited(#)" Everything is working perfectly, except for one nagging detail. I've got a field in the log file "DATE" that I'm getting back as DateTime in the report: 11/01/2012 12:00:00 AM I want to truncate this to just date. 11/01/2012 I've tried almost every combination I can think of and can't get it to give me just the date. Tried combinations of the following: Format FormatDateTime Convert Cast CDate Here is info on the dataset: query: select * FROM sample.txt Filter Expression: =Fields!Date.Value Expression for value: =DateAdd(DateInterval.Day , -7, Today) Any help is much appreciated. Chris ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ----------------------------------------- This message, and any attachments to it, may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are notified that any use, dissemination, distribution, copying, or communication of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by return e-mail and delete the message and any attachments. Thank you. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
<<image/jpeg>>
