How to convert "19 Jan. 2024" into days from today

Hang on, i just found this Calculate days between two dates

But i don't know how to convert the date format into 10/05/18

Oh and it's also confusing because here in the UK we use day/month/year not month/day/year :weary:

okay so step 1: Julian Date?

I could use the JD function (Julian Date) to convert 19 Jan. 2024.

So would that be JD(19 Jan. 2024)?

Oh shoot I can't do that because it has to be in this format:

JD( year, month, day )

so it would need to be JD(2024, 01, 19) presumably :weary:

Hmm. I suppose I could use RegEx to do this

update -- today is simply JD()

So that gives the right answer! That is super encouraging!