Forum Discussion
Solved
Add the current time to a date field in a report footer...
I've not a lot of experience with Access. I've a report which has a date field in the footer "=(Now())". I'd like to add the time to that field. Ideally I'd like the field to resemble...
"Wed. 27 Jan. 2021 3:53:46 PM
I didn't think it was going to be a big deal to make that (What I thought was a) minor change, but as an octogenarian, most things are more difficult these days. Thanks for whatever help anyone can offer.
JLOB
Not too difficult. In the Report footer, in Design View select the Date field and select Properties.
In the All tab:
Set Control Source to =Now()
and Format to dddd dd mmmm yyyy hh:nn:ss
dddd gives the day in full eg Wednesday, dd gives the day of the month, mmmm the full month and hh:nn:ss hour, minutes and seconds.
I get:
with this format.
