Skip to main content
K
KaelLizak16-Pearl
16-Pearl
September 18, 2012
Question

WeekOfYear() only works with the actual year?

  • September 18, 2012
  • 0 replies
  • 999 views
WeekOfYear() only works with the actual year? (migrated thread) Posted: Jan 30, 2012 4:39 AM

   extern.jens-uwe.nixdorf     Posts: 68   Registered: Jan, 2010


Hi @all,

i'm using the above mentioned function in a form. It should tell me the number of the week from a date, this date is set in a standard-date-field, so i use it in this way: weekofyear(name_of_the_date_field).

But it works only if in the date field a date is set from this year. I have some data-sets with a date from last year, and in these sets the function doesnt work? Why?

Thanks, Jens
Re: WeekOfYear() only works with the actual year? Posted: Jan 30, 2012 7:29 AM
Posted By:   extern.jens-uwe.nixdorf     Posts: 68 /  Registered: Jan, 2010  
Hmm, since i'm using display pattern it works also for preivious years.

regards, Jens

          

Re: WeekOfYear() only works with the actual year? Posted: Jan 31, 2012 5:19 AM
Posted By:   cstoss     Posts: 46 /  From: United Kingdon /  Registered: Jun, 2005  
Hello Jens,

Can you define "Does not work"?

Are you receiving an error? Is the number that is being displayed incorrect? Is it just blank?

Also when you say used this in a form, do you mean in a report or as a field that is visible in a Type?

If as a field, what is the definition of the field computation (ie is it static/daily, dynamic/never etc.)

Thanks,

Craig

               

Re: WeekOfYear() only works with the actual year? Posted: Jan 31, 2012 8:17 AM
Posted By:   extern.jens-uwe.nixdorf     Posts: 68 /  Registered: Jan, 2010  
Hi Craig,

it seems that i should be more patient. After a while it was working. At first only for dates within this year, but later also for dates from last year or older.

Thanks, Jens
    Terms & ConditionsAccessibility statement