Acces table Date from outside Nav

nathaliet

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

MBerger

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

Expose it to webservices, whatever virtual date table, or calendar management - you can access whatever NAV business logic via webservices...