Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-29-2012, 08:18 AM
Fields Fields is offline Complex date comparison/Selection using fields instead of VBA Windows XP Complex date comparison/Selection using fields instead of VBA Office 2003
Novice
Complex date comparison/Selection using fields instead of VBA
 
Join Date: May 2012
Posts: 5
Fields is on a distinguished road
Default

Thanks Paul

Bizzarely, that is giving me an answer of "6--22-2014" on a 28 day delay from a Date1 of 01/02/2012.

If I change the Day on Date1 (02/02/2012, 03/02/2012, etc) then I get "07--22-2014", "08--22-2014" etc. up to 25/02/2012 = "30--22-2014" and 26/02/2012 = "1--21-2014"

If I increase the Month (01/03/2012, 01/04/2012, etc) then I get "06--21-2014" "06--20-2014" up to 01/08/2012 = "6--16-2014" and 01/09/2012 = "6--27-2015"

For a Blank source date field it gives me "Wednesday, 28 March 2012".

This would be a lot easier if I could upload an attachment, but I can't do that at the moment.

My first guess was that I am running into a problem of System date setup. The local PC is set to dd/MM/yyyy format, but the file itself is held on a network server, which should also be set to the same format (and does display file dates in that format). The source field is set up as a Date-type entry field, restricted to dd/MM/yyyy format.

The standard "Find n days offset" code works perfectly in the same document, as does the "Find difference between two dates" code. Very strange.
Reply With Quote
 

Tags
arrrgh, date fields mathematics, macropod



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Fields ubns Word 8 05-15-2012 11:20 PM
Saving & reopening comparison MarshallAbrams Word 0 03-29-2012 06:19 AM
Comparison jumps to end MarshallAbrams Word 2 03-21-2012 04:04 AM
Complex date comparison/Selection using fields instead of VBA Complex array formula andrei Excel 9 02-03-2012 03:40 AM
30+ days Variable Day Date Calculations via Fields ztag Word 2 01-06-2012 11:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft