Remove time portion from a date field

[benniit]

I'm using Vb.Net 2015 with CRforVS_13_0_15 and I have a problem with a date field on the report with a datatype in the SQL database as date. This date field on the report comes with time portion. I right-clicked on the date field on the report and selected format object and clicked on "01-Mar-1999" format but still the time portion appears. Please what am I doing wrong? Thanks in advance

[former_member203168]

Hi Ben,

Use below formula instead of database field

date(datetime field)

or

todate(datetime field)

--Praveen G

[former_member11696]

Moved to Report Design forum