View Single Post
 
Old 05-29-2012, 08:18 AM
Fields Fields is offline Windows XP Office 2003
Novice
 
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