Acces table Date from outside Nav

nathaliet
nathaliet Member Posts: 9
edited 2013-11-11 in NAV/Navision Classic Client
Hi,
I need to access to non-working days defined in NAV in table Date.
I think it's a hidden table.

Does anyone has an idea on how to achieve this ? This could be done from Transact SQL or from other ways (Web services...)

Thanks for your help.

Nathalie

Comments

  • MBerger
    MBerger Member Posts: 413
    The Date table is, like you already said, a virtual table and doesn't exist in real form. It also does not contain the non-working days, so even if you were able to read it from outside NAV, you wouldn't get what you wanted. i think you need to look at how the calendars calculate the (non-)working days.
  • ppavuk
    ppavuk Member Posts: 334
    Expose it to webservices, whatever virtual date table, or calendar management - you can access whatever NAV business logic via webservices...

Categories