Need function/formula

[Jamie]

I am creating a telephone message form to be used like an
email message and want the date to appear in a specific
format. Here's the example of how I want it to appear:

Monday, 2-FEB-2004, 08:00:00

Through the properties of the form field, I have tried
every function item listed for the default field filler.
Does anyone know how to write the function to get me what
I want???

 

[Hollis D. Paul]

Does anyone know how to write the function to get me what
I want???

You have to extract all the parts of the date/time number, using the
DatePart function (not sure of the name--maybe DateTime), and then put
them back together in a string field in the order that you want.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

 

[ABoehm]

How, exactly, do you do this process? I am attempting to
do the same thing as this person. Cannot get anything to
show up in the date/time field except for "NONE."

-----Original Message-----

Does anyone know how to write the function to get me what
I want???

You have to extract all the parts of the date/time number, using the
DatePart function (not sure of the name--maybe DateTime), and then put
them back together in a string field in the order that you want.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp? FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA


.

 

[Hollis D. Paul]

How, exactly, do you do this process? I am attempting to
do the same thing as this person. Cannot get anything to
show up in the date/time field except for "NONE."

I haven't done any programming that requires that stuff in a long time,
but the following page from SlipStick.com should get you started.

http://www.slipstick.com/dev/finddate.htm

I found this using a search with the term of 'format(', without the
quotes. From the results page:

Search Results
Your search for format( found the following documents (of 554 documents
searched):
Displaying documents 1-10 of 197, with best matches first:

If you are going to be developing in Outlook, you want to become very
facile in searching at Slipstick.

For other resources see the following page:
http://www.outlookbythesound.com/sbs2003/12frameset_outlook.htm

Smell the flowers, so to speak.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA