Convert date from "internet" to "New York, USA" - Solved

[DR White]

How do I change "Mon, 23 Jan 2017 21:45:00 -0500" to "1/17/2017 11:45 AM" (Eastern Standard) ?

I have tried everything, even read several topics in the dictionary, without any success.

After six hours of trying, I cannot solve this problem.

Any help would be appreciated,

David

[Klaus]

Hi David,

no idea what "Eastern standard" is, but I doubt that the difference to internet date is really 6 (SIX) days!


Best

Klaus

[SparkOut]

Time conversion can be tricky, best start is to look up "set the useSystemDate to true" and the "convert" command.

[DR White]

Eastern standard is actually the same as New York, USA .

I just need the format to be 1/17/2017 11:45 AM form internet format.

Thanks,

David

[Klaus]

Hi David,

maybe something like this will do:

Code: Select all

...
put "Mon, 23 Jan 2017 21:45:00 -0500" into tDate
put tDate into tTime
convert tDate from internet date to short system date
convert tTime to system time
put tDate && tTime
...

But no chance this will EVER result in january 17th!


Best

Klaus

[DR White]

Klaus,

I am not where I can try the code today, I will tomorrow.

What does the "&&" do?

Thanks,

David

[Klaus]

Code: Select all

answer "Ask" && "the" && "dictionary" & "!"

[dunbarx]

Hi.

This is just a matter of parsing your input date and time, whatever format that might be in, and rebuilding it by hand. You may want to play with the "internet date", the system date, the long date and long time, those sorts of things. You will see the various parts of these functions, and then it is just a matter of extracting the pertinent components and re-assembling. It is fun if you don't have to do it too often.

What did you use instead of "&&"? The space constant? Or perhaps " " ?

In any case, do get used to "&&". Very compact, and oftentimes you will find, especially in the above exercise, that the use of "&" and "&&" usually go together when building strings, which is exactly what you will be doing.

Craig Newman

[DR White]

dunbarx,

Thanks for that explanation.

Klause,

Your date conversion code works good,

Thanks,

David

[jacque]

Or even shorter:

Code: Select all

get the internet date 
convert it to short date and time

[Klaus]

Or even shorter:

Code: Select all

get the internet date 
convert it to short date and time

Yep!

I had something like this in mind, but used the && operator (... to date && time) which threw an error.
So AND is the magic word for convert here, thanks for the reminder!

[jacque]

Alas, Klaus, your HyperCard history has left you.

[Klaus]

Alas, Klaus, your HyperCard history has left you.

Well, to be honest, I don't have one!

[dunbarx]

Jacque.

True. I have never seen Klaus reference HC. I believe he has heard of it, but that is all.

Craig

[jacque]

I could have sworn I'd known him since the HC list...that's how ubiquitous he is.