[mso] Re: Milliseconds

 
Lisa-
 
    Might you be able to get by with:
 
    time: Format(Now(),"yyyy/mm/dd hh:nn:sssss")
 
    This will return a value something like:
 
    2003/11/26 17:42:141414
 
    The snip below is from Access 2K help, while it doesn't say you can use 
"sssss" to define milliseconds, it doesn't say you can't either.
 
-Anthony
 
 
Setting

Description


General Date

(Default) If the value is a date only, no time is displayed; if the value is a 
time only, no date is displayed. This setting is a combination of the Short 
Date and Long Time settings. 

Examples: 4/3/93, 05:34:00 PM, and 4/3/93 05:34:00 PM.


Long Date

Same as the Long Date setting in the Regional Settings Properties dialog box in 
Windows Control Panel. 

Example: Saturday, April 3, 1993.


Medium Date

Example: 3-Apr-93.


Short Date

Same as the Short Date setting in the Regional Settings Properties dialog box 
in Windows Control Panel. 

Example: 4/3/93.

Warning The Short Date setting assumes that dates between 1/1/00 and 12/31/29 
are twenty-first century dates (that is, the years are assumed to be 2000 to 
2029). Dates between 1/1/30 and 12/31/99 are assumed to be twentieth century 
dates (that is, the years are assumed to be 1930 to 1999).


Long Time

Same as the setting on the Time tab in the Regional Settings Properties dialog 
box in Windows Control Panel. 

Example: 5:34:23 PM.


Medium Time

Example: 5:34 PM.


Short Time

Example: 17:34.

Custom Formats

You can create custom date and time formats by using the following symbols.


Symbol

Description


: (colon)

Time separator <javascript:HelpPopup('actip9.hlp','defSeparator');> . 
Separators are set in the Regional Settings Properties dialog box in Windows 
Control Panel.


/

Date separator.


c

Same as the General Date predefined format.


d

Day of the month in one or two numeric digits, as needed (1 to 31).


dd

Day of the month in two numeric digits (01 to 31).


ddd

First three letters of the weekday (Sun to Sat).


dddd

Full name of the weekday (Sunday to Saturday).


ddddd

Same as the Short Date predefined format.


dddddd

Same as the Long Date predefined format.


w

Day of the week (1 to 7).


ww

Week of the year (1 to 53).


m

Month of the year in one or two numeric digits, as needed (1 to 12).


mm

Month of the year in two numeric digits (01 to 12).


mmm

First three letters of the month (Jan to Dec).


mmmm

Full name of the month (January to December).


q

Date displayed as the quarter of the year (1 to 4).


y

Number of the day of the year (1 to 366).


yy

Last two digits of the year (01 to 99).


yyyy

Full year (0100 to 9999).


h

Hour in one or two digits, as needed (0 to 23).


hh

Hour in two digits (00 to 23).


n

Minute in one or two digits, as needed (0 to 59).


nn

Minute in two digits (00 to 59).


s

Second in one or two digits, as needed (0 to 59).


ss

Second in two digits (00 to 59).


ttttt

Same as the Long Time predefined format.


AM/PM

Twelve-hour clock with the uppercase letters "AM" or "PM", as appropriate.


am/pm

Twelve-hour clock with the lowercase letters "am" or "pm", as appropriate.


A/P

Twelve-hour clock with the uppercase letter "A" or "P", as appropriate.


a/p

Twelve-hour clock with the lowercase letter "a" or "p", as appropriate.


AMPM

Twelve-hour clock with the appropriate morning/afternoon designator as defined 
in the Regional Settings Properties dialog box in Windows Control Panel.








-----Original Message-----
From: Green [ mailto:1z@xxxxxxxxxxxxxx]
Sent: Wednesday, November 26, 2003 5:02 PM
To: MSO
Subject: [mso] Milliseconds


Hi everyone,

I'd like to show users the status of a process. Ray has helped me a
lot - thanks again Ray - by pointing me at the ms forms 2 listbox
because I'm using Access 2000. I'd like to append the status with a
time stamp but since Access is so fast :-) The time stamps for me at
this early stage are all the same!!!

Does anyone know please if it's possible to use Format(....) in some
way to show milliseconds?

Regards
Lisa




*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: