Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Outlook.Application Date Format
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Outlook.Application Date Format

 Post Reply Post Reply
Author
Gary View Drop Down
Senior Member
Senior Member
Avatar

Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gary Quote  Post ReplyReply Direct Link To This Post Topic: Outlook.Application Date Format
    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....

dtMeetingStart =  document.resform.startdate.value + " " + document.resform.starttime.options(document.resform.starttime.selectedIndex).text

obj.start = dtMeetingStart
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
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Gary View Drop Down
Senior Member
Senior Member
Avatar

Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gary Quote  Post ReplyReply Direct Link To This Post 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!!! Angry 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.