How about this:
PARA b,t
n=DATE()
c=DOW(b)
o=DOW(n)
?(n-b)/7
?INT((n-b)/7)+IIF(BETW(t,c,o+IIF(o<c,7,0)),1,0)
Pass it the birthday (b) and the dow() for the test date (t) and it will print the number of weeks and the number of that particular day. In your case:
do dates with {^1965-06-03},3
prints
1932.0000
1932
Cheers,
Andrew
>Well, I was reading a thread earlier this week about the quickest way to figure a birthday... it was fun to read up on it.... so, I thought that since dates are SO much fun (*wink*), why not another one? so:
>
>My birthday is June 3rd, 1965, so:
>
>A two parter:
> How many weeks old am I?
>
>and then:
> How many Tuesdays old am I?
>
>HEHEHE....
>
>Shortest combined character count wins!! Scientific notation accepted... and we are off....
>
>Ric
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.