0

Getting Start Date from Week Number.

Jet Reports Historic Posts

May 18, 2011 11:55

None

Follow

Dear ALL.

I want to get the starting date from the given week number.

i.e.(weeknumber=1)
startdate =

Please help.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts May 23, 2011 14:35

  Hi,
  
  If you are using Navision, you can use the Date table to get this information something like this:
  
  =NL(,"date","Period Start","Period Type","Week","Period No.",5,"Period Start","1/1/2011..12/31/2011")
  
  This formula would give me the start date (Monday, not Sunday) of the 5th week in 2011. Does that help?
  
  Regards,
  Hughes