Outlook.Application Date Format
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=27101
Printed Date: 29 March 2026 at 9:21am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Outlook.Application Date Format
Posted By: Gary
Subject: Outlook.Application Date Format
Date Posted: 12 March 2009 at 12:40pm
|
Hi,
I have an asp based application for booking meeting rooms. There is functionality in there that uses the Outlook.Application object to send Outlook Invite Emails - Outlook.Application.CreateItem(1).
I set that start and end dates using the .Start and .End properties of the method.
This works fine when the user making the room booking has Office 2003, but if a user has Office 2007 the date format is incorrect (eg 12 March 2009 becomes 3 December 2009).
However, the Invite Body contains various details of the room booking - including the start and end dates. For examlple Request.Form("StartDate") and this displays correctly in the invite body (eg "Meeting Start: 12/03/2009")
The only difference that I can see in the code is that the object Start is determined using javascript as follows....
Any suggestions? (What I am after is a solution that will work for Office 2003 and Office 2007 users). Is this a bug with 2007?
Many Thanks
Gary
|
Replies:
Posted By: 123Simples
Date Posted: 12 March 2009 at 2:27pm
|
You should probably check this with the vendor of the application (I assume you have purchased this asp booking application) or have you created it? If it is a vendor application, then perhaps they can advise you ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: Gary
Date Posted: 12 March 2009 at 2:32pm
|
Yes, this is an app purchased from a 3rd party vendor, whom I have emailed for advice.
I think we are going to run into problems as I dont think they support this version any more (app is 7 years old).
I have customized other areas of the code previuosly (not related to dates though) and would be happy to do so again. It's just that I dont know how to resolve this particular issue.
In fact, rolling out Office 2007 in my company has been, and continues to be a total pain in the rear!!!
 |
Posted By: WebWiz-Bruce
Date Posted: 12 March 2009 at 2:39pm
|
It looks like one is setup for intentional dates and the other for US dates. What about trying to change the date format you feed in. From past experience find that using an ISO format date of yyyy-mm-dd often fixes date compatibility issues. So instead the date you feed in would be:- 2009-03-12 ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |