DateTime fields, methods over such fields, DateTime depended SQL where-clause and SQL-functions.

Ruslan Zasukhin sunshine at public.kherson.ua
Thu Dec 9 19:19:16 CST 2004


On 12/9/04 6:59 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

>> It is the same to WEEK function.
>>  Week( date, [firstWeekDay] )
>>  Returns the week of year in the range of 0 - 53
>>  firstWeekDay == 0 - is for Sunday
>>  1 is for Monday and so on... up to 6 (Sat)
> 
> Thanks, but this is my problem. IMHO do we have several calculation
> methods. 

> The US-Method says 1.1.YYYY ist week 1 using DIN week 1 ist
> where the first thursday is in. So you can have 01.01.XXXX in week 52
> or week 53 by DIN but week 1 in US Method. The information when is a
> new week starting is a good thing, because US-week starts on sunday and
> by DIN on Monday.
> But after that, what is calculationMethod in Valentina?

Claudius,

Please give us exact example. Ivan will check.
Or you can check self right now with latest V4RB.
 
Give us some date, 

    what you get in RB
    what you get in 1.x
    
    what YOU WANT to get.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------




More information about the Valentina-beta mailing list