# Formatting fields

**URL:** <https://forum.servoy.com/t/formatting-fields/14103>\
**Category:** Classic Servoy\
**Created:** [June 6, 2011, 12:38pm UTC](https://forum.servoy.com/t/formatting-fields/14103 "2011-06-06T12:38:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![michele](https://avatars.discourse-cdn.com/v4/letter/m/ed8c4c/32.png) [@michele](https://forum.servoy.com/u/michele)\
**Post date:** [June 6, 2011, 12:38pm UTC](https://forum.servoy.com/t/formatting-fields/14103/1 "2011-06-06T12:38:14Z")

</div>

I need to know if is it possible to format a date field to insert only the values of the date but not “-”…  
I need also to have numeric values with zero value to not display the 0, but only spaces…

Thanks

---

<div class="post-metadata">

**Author:** ![Joas](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/joas/32/5095_2.png) [@Joas](https://forum.servoy.com/u/Joas)\
**Post date:** [June 6, 2011, 1:16pm UTC](https://forum.servoy.com/t/formatting-fields/14103/2 "2011-06-06T13:16:52Z")

</div>

> michele:  
> I need to know if is it possible to format a date field to insert only the values of the date but not “-”…

You can use “ddMMyyyy” as the format. It is also possible to use a different format for showing and entering, for example “dd-MM-yyyy|ddMMyyyy”. The third option is to have a format like “dd-MM-yyyy” and then check the “Use as mask” checkbox in the format editor. That way you see the date with “-”, but you only have to type the values.

> michele:  
> I need also to have numeric values with zero value to not display the 0, but only spaces…

I don’t really understand this one. So you have zeroes in your db, but you want to display something else? I think the best way to do that is to create a calculation that shows spaces instead of zeroes.