Backwards compatibility Notes 5 to Notes 4

I should have searched first. I've just found a useful previous answer -
https://www.experts-exchange.com/questions/20253721/Open-R5-db-into-R4.html?query=Notes+4+5&searchType=topic
I'll try that and add a further comment to here if it doesn't work  :-)
Thanks

Do you guys get automatic notification of a new question? You are amazingly quick! Thanks hshevitz, I'll try this - it might be that easy.

Yes, we do! Makes it a real good way to keep up with topics.

HS

Besides a few typo's in your example, I can't imaging that it'll cause any problem.
Have you tried File > Database > New copy and naming it *.ns4?

Typos? Me?? Never!!! OK, you're right. The strange thing is, I made that typo on the first line (it should say "Select Today < @Date(@Now);" in my database, and the routine works fine! The typo on the second line (missing colon) was me typing in my question badly. I find Notes amazing - it doesn't work when you expect it to, and now vice versa.

In the reference above (https://www.experts-exchange.com/questions/20554031/Updating-all-the-documents-in-a-database.html) the answer seems complicated, and I had expected it to be less than easy. However your suggestions are spot on - I made a new copy, altered the extension, opened it in 4.6.1, and it's fine. Many thanks.

I got two correct, same answers. In terms of clarity, CRAK's answer was clearer, but this one came first. Preferential treatment for you next time, CRAK! Thanks to both.

...and what about that link you've given. Doesn't it demonstrate that I was first? And looking back on it, it wasn't all that hard to understand, was it?
;-))

Actually I was referring to the missing square brackets in the @Command, the missing ":" in Field Today:=... and your're right: the semicolon.
Why not use copy/past next time... it save time, reduces the number of errors, helps us to provide correct answers faster and gets you on track sooner!
You're more than welcome to post points in a "For CRAK"-question for this otherwise free tip!
<GRIN>

C U around!

What square brackets??
No, 6:14 definitely comes after 4:49.
Sometimes copy/paste is slower, but you're right, more accurate. I shouldn't always be in a hurry.

For interest, I've found that if I type in (ignore the typos please - they're sopy and pasted !! <GRIN>

SELECT Today<@Date(@Now);
FIELD Today=@Date(@Now)
FIELD DaysToGo:=(Deadline-Today)/86400

then Notes changes it to

Today<@Date(@Now);
FIELD Today=@Date(@Now)
FIELD DaysToGo:=(Deadline-Today)/86400

Are you acting or have you honestly not noticed?
You "sound" like a funny guy.... I can't be sure!

@Command(ToolsRefreshAllDocs)
should have read:
@Command([ToolsRefreshAllDocs])

The Select statement is automatically removed when it's not supposed to be there. If you need Select in a button, you probably need to trigger an agent.
Without the select, the 1st line is interpreted as a boolean expression: it returns either True or False. (such typos in field formula's often display unexpected -1 or 0 values)
Either way, the formula continues.
The next line puzzles me a bit. Field <fieldname> should be followed by ":=", not "=". The end of the line should have ";".
The last line - I admit - is free of typos! (Unless you mean @Today, instead of the field or variable "Today").

A couple more questions....
(1) You're right about the 4:49 etc. But where did the 6:14 come from?
(2) When I'm born was the afternoon and my brother was borm in the morning but on a different date at least two years later... who do you thing is the oldest of the two? (programmatic approach is allowed, not required. No prizes to be won either way!)
(3) Do you appreciate me still being around to help you?
(4) Where's the For CRAK question?
;-)

Thanks for your reply, CRAK.

I like to be light hearted in style, but I only post serious comments. If you think I'm being dumb, just humour me - it's not intentional, it's just that I'm a beginner really.

Now that I look more carefully, you're right. My working database command, pasted from the expert's reply, does have square brackets as well as braces, and I hadn't noticed, so my omission of them in the current question was partly typo and partly ignorance. Sorry; as stated I'll copy & paste more.

Thanks for the comments on typos. Let's drop that bit; the real code in the database is correct and works fine.

(1) Now the timings. According to my screen, your first reply above is dated 03/25/2003 06:14AM PST, whereas hshevitz posted his first reply at 03/25/2003 04:49AM PST. He actually posted it whilst I was doing my first search (I've only just joined as a subscriber) and found what appeared to be a suitable previous answer. Hence my comment on speed of response! Anyway, he seemed to get there first.
(2) Tres bien. Is this my first clue that you're not English speaking? ;-)
(3) Definitely, yes
(4) I didn't have one, but I'll post one just for you now....  it's a real question and I'd value your answer.

Stuart

Found it!
Actually I was joking about that date thing and referring to the post that you found. But since it's common knowledge / not copyright protected, I'll let you guys get away with it! ;-))
Tres bien? Where are you from? I'm dutch and the editing in (2) wasn't perhaps such a good idea. Some major typos there! I'll learn to live with it: it happens more often!

And I never called you dumb! I was a beginner once too! In fact, I've just joined a course in Oracle. I didn't know a single bit about it and have to examine my own code to the letter to find even a single error. Even when I made dozens of typos in it!

But I blame the keyboard.... I suspect it's got a will of its own!

I'm English. I should have guessed you're Dutch - I've always found Dutch people such excellent speakers of English.  
No, I know you didn't - I just feel I might appear that way sometimes.
Me to - but I know I ought to learn to touch type.

I am a vry gdoo typre... vey fats (>700/min) bu te kyebaodr can't kepe up iwth me!

If the Dutch are excellent speakers of English, then why was the term "Dunglish" invented?

Where in England do you live?
Leave some more info in your profile!?

Yes, I've got that problem too!
Don't know, but I'm speaking from expereince of several visits.
Chester.
OK.