Free Support Forum - aspose.com

Cleaning up DateTime

I created a pdf by passing it a datatable. Everything looks fine execpt for the date. SQL adds the "12:00:00 AM". Is there a way I can filter that out. I know how to do it within a datagrid but how can I do it here.

Dear hankddog,

Thank you for considering Aspose.

Sorry I can’t understand your problem exactly. Can you please elaborate it?

Sorry. When I pass the datatable to the pdf all of my datatime fields have an extra “12:00:00 AM” that sql adds. If I was passing my datatable to a datagrid I could filter out that time by using. .DataFormatString = “{0Big Smile}” I don’t want that “12:00:00 AM” to be shown in the pdf. Is there a way to filter that extra time out?

Dear hankddog,

Thank you for considering Aspose.

This function is not supported. But I will study this issue and see if it is easy to support.

OK… Just an FYI… We were able to get around it by modifying our sql query using CONVERT(varchar, dbo.Employees.Termination_Date, 101) AS Termination_Date

Thanks