Forum Discussion
Helper ICalendar since September Update
Hi Terry,
The cause is the dates in [fact***entry] are datetime rather than date. I added a new column and changed the relationship. It returns normal now.
New key Date.Datetime = [Key Date.DateTime].[date]
Best Regards!
Dale
Helper I
I'm trying to create a calendar that links the two datasets so I can cut the Bill Net from both sets by year, month, date etc.
Let me know if the link doesn't work. Thanks for all your help.
Regards,
Terry
Microsoft EmployeeHi Terry,
You have to share the file first. I can access it.
>>>We're sorry, but xxx can't be found in the cmacgroup-my.sharepoint.com directory. Please try again later, while we try to automatically fix this for you.
Best Regards!
Dale
- v-jiascu-msft
Hi Terry,
The cause is the dates in [fact***entry] are datetime rather than date. I added a new column and changed the relationship. It returns normal now.
New key Date.Datetime = [Key Date.DateTime].[date]
Best Regards!
Dale
- CMAC_Terry
I think I need your email address to share, could you post.
Thanks,
Terry
- v-jiascu-msft
Can you share the file publicly? Google Drive, Dropbox are also OK. You can send me a message.
Best Regards!
Dale