How do you exclude the time stamp when running a livereport that inclcudes a date system attribute?

Is it possible to exclude the time stamp when running a livereport that returns the value of a date filed? To ellaborate, we are running a report on correspondance where a configured attribute for Due Date has been set. We want the report to the date only and not the time. Please let me know if there are any SQL or other workarounds?Jonathan

Find more posts tagged with

Comments

Donna Nalls

Hi Jonathan,You should wrap the date field in a date formatting function. The functions are different based on your database.If you need an assist, please respond and let us know what db you are using. Best,Donna

Simon_(INACTIVE)_Scoble

Hi Donna,We are using Oracle 9i. Thanks,Jon

Donna Nalls

Hi Jon,Try something like this:to_char(createdate, 'mm/dd/yyyy') as "Create Date"the first arg to the to_char() is the field and the second arg is the specific format....you may be using 'dd-mm-yyyy' instead of my 'mm/dd/yyyy'.i usually add the "as ; otherwise the column header will display as your to_char(...)Best,Donna

Simon_(INACTIVE)_Scoble

That's great - worked a treat. Thank you for your help.Jon

Krishna_Konepally

How can i convert the live link date to a c# date.I am trying to display the metadata field which is a date in C# windoes form textbox. right now it displays it as d/2004/2/2:0:0:0 is there a way I can format it to look like just 2004/1/1

Carsten_Kulms

Message from Carsten Kulms via eLinkThe documentation seems to be confusing but there should be a LLValuefunction toDateNET() which returns a System.DateTime object. This shouldbe formattable by usual C# date formatting ways.