Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 06-06-2012, 07:38 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. I'd validated all the fields before, and re-done the code but couldn't get it working. Starting from scratch in a new document worked. Maybe it had genetic memory of an earlier error.

For reference, if I wanted to "set" this calculation to a variable, wa my original syntax workable, omitting the "quote" instead? E.g.

Code:
{set 28days{=
{Set delay 28... Etc}
this worked for "storing" the difference between two dates but not for the 28 day calculation. I think it might be due to my lack of understanding of the use of "quote" in the original code.
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 08:15 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