Date formatting question... 1

[PaulChilds]

Hi,

I want to put a date on a report. The date is the day and time that the report was printed/viewed. I have no problem putting in =Now() but the format in which I want it to appear is not so easy.

I want to use the medium date format (19-Aug-01) and have the medium time follow it (05:45 am), but I want the time to be in brackets, so it should look something like:

19-Aug-01 (05:45 am).

Any ideas?

Paul C

http://www.worship-leader.co.uk

http://www.liverpooldream.co.uk

http://www.ormskirkparish.co.uk

http://www.cadetsltd.co.uk

 

[KenReay]

Hi

Format(now(),"dd-mmm-yy (hh:mm)&quot

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[PaulChilds]

Thanks, that worked good.

Any idea how to get am/pm in though? If not never mind.

Paul C

http://www.worship-leader.co.uk

http://www.liverpooldream.co.uk

http://www.ormskirkparish.co.uk

http://www.cadetsltd.co.uk

 

[KenReay]

Hi

Sorry, missed that in your post

Format(now(),"dd-mmm-yy (hh:mmAMPM)&quot Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[PaulChilds]

Thanks

http://www.worship-leader.co.uk

http://www.liverpooldream.co.uk

http://www.ormskirkparish.co.uk

http://www.cadetsltd.co.uk