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
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.