Forum Discussion

Chris2B's avatar
Chris2B
Helper I
2 years ago

Date tables - Sage 200

Hi I need somehelp with my date table. I have a live dataset that has been integrated from Sage 200, however I am having a major issue with my date table. It is pulling all the way from 1818 inste...
Need Help
Tutorial Requests
Chris2B's avatar
Chris2B
Helper I
2 years ago

Sorry I am not understanding? I have tried adding a closing parenthesis but I still am getting errors. I sipossible to help me rewrite it.

 

Thanks

 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

     CALENDAR(MAX(earliestdate,"1900-01-01"),COALESCE(latestdate,TODAY()))