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.
Super UserCheck if the date coming from SharePoint is having timestamp in it. And it is not visible because of the format. And that is casing join to fail.
Helper IIAfter making changes do I need to hit a button to see the data?
- vanessafvg
Community Champion
ComputerHabit look at the display format in the visual pane under modelling for the sharepoint date, have you previewed it in the query pane? (ie edit queries)
- ComputerHabit
Nothing. No luck. I have tried various formats and changing the field to date and date\time back and forth. Nothing happens. Is there a debug button or anything?
- ComputerHabit
Dates appear to be the same.
- vanessafvg
what is the date type for the created column? have you got it as date time?
PaulDBrownIs the relationship linking your Date field from the Date table to the "Created" field in your "Events" table?
- ComputerHabit
Yes. I'm linking the Date field to the Created field.
