Home
Designing Analytics Reports
convert datetime to string
HSMorales
Hi I am new to BIRT and am working on a report that uses a stored procedure for my dataset. One of the fields being returned "Date" is returned as a datetime field in the format "MMM dd, yyyy hh:mm AM". Another field being returned is a string field we'll call "Type". I need to create a computed column that is of string type. When the "Date" field is null, this field should equal "Type" else it should equal "Date" in the format MM/dd/yyyy. How can I accomplish this when one field is date and the other is string ?? Help would be greatly apprediated. Thanks
Find more posts tagged with
Comments
There are no comments yet