Date Excel - Dyalog

APL-related discussions - a stream of APL consciousness.
Not sure where to start a discussion ? Here's the place to be
Forum rules
This forum is for discussing APL-related issues. If you think that the subject is off-topic, then the Chat forum is probably a better place for your thoughts !
Post Reply
Tranber44
Posts: 36
Joined: Mon Jan 11, 2010 4:46 pm

Date Excel - Dyalog

Post by Tranber44 »

Hello,

I am amazed to notice a very annoying difference between the interpretation(performance) of Dyalog and that of Excel

APL 13.0
+2 ⎕NQ '.' 263 16254
1944 7 2 6

Excel
Format date DD/MM/YY
16254 -> 01/07/44

Why this difference?

Thanks
Top
User avatar
Phil Last
Posts: 628
Joined: Thu Jun 18, 2009 6:29 pm
Location: Wessex

Re: Date Excel - Dyalog

Post by Phil Last »

Try these in Excel:
      +2 ⎕NQ '.' 263 59
1900 2 28 2
      +2 ⎕NQ '.' 263 60
1900 3 1 3
then try to work out which is correct.
Top
Post Reply

Return to “APL Chat”