Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format Now()

Status
Not open for further replies.
andy570

andy570

Technical User
Jan 5, 2004
40
US
Hello quick question. I have Now() displayed as 2004-07-06 01:36:15.0 I would like it displayed as Monday, June 07, 2004, 1:36:15 PM. What is the correct expression? Thanks!
 
Sort by date Sort by votes
Hi,
[tt]
Format(Now()< "dddd, mmmm dd, yyyy, h:nn:ss AM")
[/tt]
:)

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Upvote 0 Downvote
When I enter that in the default field I get the following error when I try to save it: Error "Type mismatch" in the default value. Thanks for your help.
 
Upvote 0 Downvote
Sorry,
[tt]
Format(Now(), "dddd, mmmm dd, yyyy, h:nn:ss AM")
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

03Explorer
  • Locked
  • Question
Refreshing a linked table (housed on MS SQL Server) now breaks
Replies
3
Views
379
dhookom
dhookom
lazyadmin
  • Locked
  • Question
3 tables with related data. What now?
Replies
7
Views
166
kjv1611
kjv1611
MICKI0220
  • Locked
  • Question
export table without time format
Replies
1
Views
55
SkipVought
S
tamer64
  • Locked
  • Question
External Table is Not in the Expected Format
Replies
2
Views
84
Darrylles
Darrylles
techkenny1
  • Locked
  • Question
Exporting a table to CSV format 1
Replies
1
Views
60
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top