Android Question Format date-type field in B4Xtable

[Mostez]

date type fields displayed like '7/25/2020 12:00:00 AM' in B4Xtable, I converted it to string type on SQL database to get ride of time part, but it makes problems with sort and search between two dates in my application. is it possible to format this field without affecting its type?

 

[Erel]

The format is based on DateTime.DateFormat. Converting to string is a mistake.