BIRT REPORTING in I need to remove time for the date

Question

I need to remove time for the date column I dont why the time is coming can any one help me

Answer 1

You can convert datetime to string in your SQL procedure. Here you can find the formats.

For example, if you want to convert datetime to format dd-MM-yyyy, use query:

CONVERT(NVARCHAR(10), GETDATE(), 105)

If you want to sort data using date, leave the actual date in your SQL procedure. This date you will use for sorting, and string for display. Don't use string for sorting because it will use alphanumeric rules.