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.
|