|Subject:||Re: date grief
|Date:||Tue, 12 Dec 2017 08:46:54 +1000
|From:||Leslie <"ViaThe List"@NOSPAM.com>
On 12/12/2017 8:03 AM, Bernie van't Hof wrote:
> And how about:
> CHECK calc 24-Jun-2016-2..
> CHECK calc 24-Jun-2016+2..
> (same result)
> ============ Answer ==========
> ANSWER | Date | Blank |
> 1 | 1-Jan-2011 | |
> 2 | 23-Jun-2016 | |
> 3 | 24-Jun-2016 | |
> 4 | 25-Jun-2016 | |
> In contrast to:
> CALC 24-Jun-2016-24-Jun-2016 => OK (0)
> CALC 24-Jun-2016+24-Jun-2016 => "Type Error"
> I think we're done: MATH + WILDCARD = ERROR
> - Bernie
Yes and No.
*Day* arithmetic after a date pattern works, any other combinations will
probably produce an error or do nothing.
Having said that, I think it likely that Date Pattern + Day Value only
works because of how the parsing works and not by intentional design.
So without the actual documentation, I think you are within your rights
to claim it to be unsupported in your new world. You could always
revisit if any additional information comes to light.
Of course if the goal is not an emulation, then you could make your own
date parsing rules up when patterns are involved.
This email has been checked for viruses by AVG.