That is way too long of a line: I only have 40 Gb hard drive <g>. Just kidding. Thank you very much, Sergey.
>I'm not sure if't shortest but it's one-liner. :)
>
? DATE(nYear,1,1) + nDow - DOW(DATE(nYear,1,1)) + IIF(nDow < DOW(DATE(nYear,1,1)),7,0)
It doesn't take into accout SET FDOW, though.
>
>>What is the shortest formula to find first Monday (or any other day of the week) of a year? For example, if
>>
>>
>>nDow = 2
>>nYear = 2004
>>? DATE
>>
>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
