0

Date table

Jet Reports Historic Posts

November 09, 2011 21:04

None

Follow

Hello

I have a given datefilter like for instance 09-11-2011..05-01-2012.
I would like to calculate/count number of days in November (22 days), December (31 days), January (5 days).

How can I do that - maybe by using date table in Navision ?

Thanks for any help.

Br. mdp12.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts November 09, 2011 21:23

  Hi,
  
  Attached is an example to do something like this. Does this make sense?
  
  Regards,
  Hughes

  • Date Table Sample.xlsx
• 0
  
  Jet Reports Historic Posts November 10, 2011 08:00

  Yes, it lead me in the right direction.
  
  I needed to specify the middle months, so I used the navision date table to replicate rows with
  the middle months, and excel functionality (=date) to calculate days in first and last month.
  
  Thanks for your help.

• 0
  
  Jet Reports Historic Posts November 10, 2011 08:26

  And to output it per month

  • Day Count per Month for Period.xlsx