Hello group,
Medical insurance (in the US) requires a date/time stamp message when an electronic signature is used on a report: "Electronically signed by Jane Doe 7/10/2015 10:05 PM". The message is in an unbound control on the report. When a user does not have an electronic signature only their name is displayed. The date/time is retained with the record.
When I use Format(Now, "mm/dd/yyyy hh:nn A/P") I get "07/10/2015 10:05:00 PM".
The input mask in the table and the control on the form for this field is "mm"/"dd"/"yyyy h":"nn "A\M;;_
How do I get rid of the seconds (":00")?
Thanks,
Bill
Medical insurance (in the US) requires a date/time stamp message when an electronic signature is used on a report: "Electronically signed by Jane Doe 7/10/2015 10:05 PM". The message is in an unbound control on the report. When a user does not have an electronic signature only their name is displayed. The date/time is retained with the record.
When I use Format(Now, "mm/dd/yyyy hh:nn A/P") I get "07/10/2015 10:05:00 PM".
The input mask in the table and the control on the form for this field is "mm"/"dd"/"yyyy h":"nn "A\M;;_
How do I get rid of the seconds (":00")?
Thanks,
Bill