A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

format



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 6th 08, 12:20 AM posted to microsoft.public.outlook.program_vba
Joel Allen
external usenet poster
 
Posts: 117
Default format

Hi,

I need to get yyyy/mm/dd out of this:
FormatDateTime(Item.UserProperties("HardwareDueDat eRequested").Value(),2)

Can someone please help. I looked and look, found the DatePart function but
I think there must be an easier way.

Thank you for your help,

joel


Ads
  #2  
Old May 6th 08, 12:50 AM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default format

This is for code on an Outlook form? Use the Year(), Month(), Day() functions.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Joel Allen" wrote in message ...
Hi,

I need to get yyyy/mm/dd out of this:
FormatDateTime(Item.UserProperties("HardwareDueDat eRequested").Value(),2)

Can someone please help. I looked and look, found the DatePart function but
I think there must be an easier way.

Thank you for your help,

joel


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to tell which PST format I'm using [email protected] Outlook - General Queries 2 July 18th 07 09:37 PM
Format of phone numbers automatically chaning format leysy Outlook - Using Contacts 1 April 29th 07 12:27 AM
Mail Merge - Format/Send Text and HTML Format srm Outlook - General Queries 0 January 17th 07 06:15 PM
How to change CONTACTS format on outlook 2003 to previous format Changing format of all contact records Outlook - Using Contacts 3 March 15th 06 10:51 PM
I need to save a contact in SMTP format not exchange format. JAX Outlook - Using Contacts 0 February 15th 06 01:51 PM


All times are GMT +1. The time now is 03:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.