Format date/time without seconds 1

[belovedcej]

I have a form which a control with a default value of
now() so we have the date and the time.


The format automatically is date hh:mm:ss Meridian

The users sometimes change the date and time in this field, and they don't like the seconds.

Is there anyway to get rid of them easily? BTW - this is an unbound form/control.

 

[Remou]

How about:

[tt]Format(Now(), "dd/mm/yyyy hh:nn")[/tt]

 

[belovedcej]

Thanks for the suggestion.

It worked to format it, but when editing it, the format changes back to the original. I think I must need an input mask instead of a format. I'll try to adapt your suggestion in that way.

 

[belovedcej]

Got it - thanks Remou. I used your expression for the default value, also changed the format to dd/mm/yyyy hh:nn and then created and input mask of date/time type that looked the way I wanted.