Forum Discussion
Date table returns blank months
What seemed to do the trick was to in the query editor, go to the transform and extract the datetime value to just date.
Thanks for the help.
I changed the query under the transform tab for the sales table date from date/time to date.
Still, if I format under the modeling tab to date/time I get 2 different times 1/1/2018 00:00:00 and 1/1/2018 12:00:00.
When I filter on the blank yearmonthnumber --> all the fields are 1/1/2018 12:00:00.
This suggest there's something with the formatting. Any way to fix it? I don't want to have the clock in the dates table, but rather remove the time in the query. But that seemed to not be possible?
What seemed to do the trick was to in the query editor, go to the transform and extract the datetime value to just date.
Thanks for the help.