Need a sample dataset and an example code to work on canonical calenders.

[Anonymous]

I need an example code and a data set to understand the working of canonical calendars. I've seen a post published by HIC (Canonical Date) in the community. But i need a very detailed explanation of the canonical calendar with some examples. Please help.

[rodjager]

Hi Aravind,

There are lots of sample data sets available through the web such as the NorthWind and AdventureWorks data sets from Microsoft.

Alternatively, if you want to create your own unique set then I can recommend https://mockaroo.com/ which is a data generation site.

Hope this helps.

Rod

[sunny_talwar]

May be look here for some of the examples other posters have posted

Multiple dates in same table

Common Calendar for Multiple dates in Multiple tables