Andy Maskell

Can anybody recommend an external/package that can take the output from the 

 object and reformat it into a long date in text format?

eg 3 13 24 becomes Wednesday, 13th March 2024

long-date-formatter

the day of week could be created arithmetically, at least for the past and the next few years, but i am too lazy now.

you are looking for the "doomsday method" by john conway.

@SourceAudio Actually this didn't help much as it only returns the date in short format - dd/mm/yy - which is much the same as I can get with the 

So, I've ended up writing my own routine to do what I'm after.

For those that might be interested, I got the day of the week with this expression:

[expr ($i2 + $i1 + (5  (($i3 - 1) % 4)) + (4  (($i3 -1) % 100) )+ (6 * (($i3 - 1) % 400))) % 7]

 objects to translate the day and month from 

1714.3oc6Zs0aaaCE94Tf9efvnEHYyMP7ltr2JvPen.c6gNf8PQQfrEiiRkk

DzkzjUr+6iWjjkiMkIqjLPKVQgjIE0gemC+3GOhLe6ku3hEqxdjUt.7afOAt

3huwq4BYchZtnshKVrM7w0IgkxFtHk80rU2uXYyypXOVIquBrBrpq5z5swoI

rJ46.6UaVcUa0n1pU0U8TNSAkEqBS2rXYycvmaaWbjrm3c+aHc8TdX056hS2

bSAack58It3qcVBvdxqHwUD+J3yxW4ee4KD242VNZmt.TrN4KG2qcNtW2ELV

sYcVRVgBxNWGPQAD3R9untDOGWwubB7cvAKAPA30FsNdDBBoFDiTgHxtPTeW

bO74rr2E3nhlaYkkgaXGFNKYUGOVhNQrzvXBANTHABkgAh5Vv0zYi1TY4LE3

5zNzOaNaYdQbZ0sfWWJ+e7w8b7zLBiGTXf5PkNpmzqC7

mSkANfYfxm1tJKwJNsdUQghnFuFOjWifN8H1ddynWyULR.QYe0J1MYXOd4fd

NxDOWMylhNTlS.3ahBqBa71V2U7j5ToY7V1VUa69jrk6ZK+Qeg8TeMeQUODl

T25HeHKMJj2hO293ln8wsBTiU9qZVoElAowL+MKJ0JCg0gm6pKrwNDM14cEw

VXEpFq7wvp5BKriqN6Te3XUaAgAaXNkgOvhtgyA4rsaBqpJhWwmwWd.OhscE

KZuQ0E4bFZbYbVpDFcVdxmMxdLu.b4qhQfeE7pXH+5kTvu.tjWEF7F.7JvqA

jqtRTOYW8xpgNNWAth+.2CdA9StR7CutNLINk0McAMmx6POCltCccUqfqxBz

8Ge8cnqIqpo79yf9d3SU2c1T3GNM1FeG5K8cZv2kBOFZgDuNwYXY0XElQoQi

URFWDMV0XBevcjRwTyMgNUXWyMgmFS3YtI70XBeyMQfFSDXtIf5Re.5XgQzR

PgVXDcTTHxBinijBwVXDczTnE7TnNhJzBlJTGUEZAWEpirBsfsB0QWgVvWg5

HrPKXrHcLVjELVjNFKxFMUshpVnphzwXQVnqhzwXQVvXQ5XrHKXrHcLVjELV

jNFKxBFKRGiEYAiEoiwhrfwh0wXwVvXw5Xr3CXr+X9kCm2raG7a3o9jyZ1sa

yROiY25Yfq2jbqZCasN41cKkOhjaeeXZcXwn24g2wVUXiczIG+gvh02M17be

adQbxXyz8Cie+FdecJaro5995jmFattusdSs4q2pSK9ir7JgvUwnS58OWWkY

iczwc+irGrCP5Xu+Na8QLzOlB70o2mEmBvmMgNjAGFEDIU2ovYTiOIKLRb9S

.tXHahNDFMKqYfG6JcX+4bQMq8SrV+LIlqOrb28XwJLGcW4Mv0CjN8tyeZNN

OwtMntCNErRVZUXEeFVeHIgh7hmbuCoN8Wk8VdJAkw+iLLH1NwuqinT.p64B

rw2FuV1+68z3MoYb7jDu9K6Uee.+ccdXCtygXYzG6HuQbIG55O6PpO7PfeVC

QmtkaJBihYMImr60uMNIQZhaZcpEpt9XMQdEZBpd16zgOzxdWF9crqaBqqx5

6hN63K60rzMIL02WooE4EY4YEsC7NWSm94Gh8PAHSlh+k7HhYSS9obdB0foI

z+eZxO0SSxCSYIVuTQvdDASVf04jj19B39VHfqNKDm8Pz1rH1d8ptPpgChmJ

dqZo7LAe9eYYRGP7fmMJTlUWrtc9YSpSfdcYDiKGj1El9TWRFfAyZv7tSbFS

mtCISWGhLxAEcHr2HYbTNOo8plvJM.K+STBKOzKJUsMIhR89aEqHhIGScNen

NX+VoC0TwMJxuqzQPMbJPsQishSXcpFbcMdvch5POi5Pzj0gn84kZhnzA4AD

e70P2d+y2Ubx8NRVAjHtIKMSbYgKfNoK3seqlTdoYAQuAk.zFDkoq31FDclQ

WvwHWX.dfGRBSNZ8DJAvfcEmQXiLZ9IROr4xX93d+CRDnFcMhidWWE+c+hH9

xyBWrUATVbFo2mbjw3AFmNPKKMSXFaBlmNQLrYqlMcYYfMxAEev9.y3alef7

k6QFwmzUZZvHwDLRGNuDk5MlHQZCDkklFHFXyxq5vXSdGtzdq2HKMIXznnHb

xXVDSVJg.Ow5wxPgqbROxo82SC9fFy70CPElPAARQTbvtRyzxDlgZpAfVP9Q

cfVUZlDQMJUP3wUQa9xsv77GXEsmAgpq3en78pONTc5Qb+LUUVcpVKJXOzcr

EpOicgXakhq3epZcgZeJdzsYGljeSZQZcb6PUyYmrP9s3ogaYk4gJ2R9M6u7

hm, does not work for future centuries. is the century / 400 years base day included here?

I haven’t tested a huge range of dates but it got my birthday right from back in 1959 and it got this years leap day in Feb correctly. The 400 year exception is covered in the last chunk of parentheses. As it’s only being used to give today’s date in long form, I don’t feel inclined to worry too much about future centuries! 😂🤣😂

10th October 2011 was a Monday according to my diary so the equation should give a 0!

date /t used to work on older systems, where one could set short date format to DDD  etc.

monday should be 1 and not 0, and your expression gives me 4, which is why i am unsure if i used it correctly.

but you are right that it is a monday. so, as it seems, the online calculator i previously used also does it wrong. this one does it right: 

turns out to be more complicated than i thought.

Actually - one can set short date to show day of the week also in win 10

I don't use windows really, but who does so should know about this things....

I've tested some more dates using my formula and I am getting some errors. So it might not be the best solution after all!

I've now got SourceAudio's PowerShell method to work so I'm going with that:

Operations on dates (record conversions, calculating distances between dates, etc.) are probably best performed using JavaScript.

@SourceAudio As usual, Max is playing stupid with quotation marks!!!!

powershell get-date -format "dddd dd MMMM yyyy"

, how can I format that in a message that Max will use without stripping out the required quotation marks?

powershell get-date -format 'dddd dd MMMM yyyy'

Alternatively, here is another algorithm that I have read up about that appears to work. This takes into consideration all the quirks with leap years in the Gregorian Calendar based on the 100 and 400 cycles. The output is 0 == Sunday to 6 == Saturday.

it outputs negative numbers (?!) for years greater than 2700 - but we can fix that later.

of course, to express our nerdiness best, we should put it in a single expression:

($i2-2)+($i2<=2)*($i2+12)))-0.2)-(2*int((($i2>2)*($i4)+($i2<=2)*($i4-1))/100))+((($i2>2)*($i4)+($i2<=2)*($i4-1))%100)+int(((($i2>2)*($i4)+($i2<=2)*($i4-1))%100)/4)+int(int((($i2>2)*($i4)+ ($i2<=2)*($i4-1))/100)/4))%7

the spaces have to be removed because otherwise it is too long. 8]

@Roman You’re welcome to it! 😂🤣😂

I’ve gone with @SourceAudio’s method though as it was easier to code and puts Windows in charge of working it all out!

Long date formatter - Resolved