Forum Discussion
Helper IIDate Table not working with relationship
There appears to be two different places to format data.
When using Get Data and bringing in the initial SharePoint list the Date columns come as Any\Text. I had initially left it like that and made my Date table and joined them. I initally tried changing the data type in the relationship area. That didn't have the desired effect. Only after going back to the Sharepoint list data and modifying the CreatedBy column from Text to Date did it start working.
Helper III'll retry after lunch. Ugh...
It's odd that a single date is showing. Is everyone sure there isn't a secret button?
Community ChampionComputerHabit one step closer right? are you sure you have all the dates? compare the tables side by side, remove the relationship
- ComputerHabit
There appears to be two different places to format data.
When using Get Data and bringing in the initial SharePoint list the Date columns come as Any\Text. I had initially left it like that and made my Date table and joined them. I initally tried changing the data type in the relationship area. That didn't have the desired effect. Only after going back to the Sharepoint list data and modifying the CreatedBy column from Text to Date did it start working.