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.
Super UserAnonymous , Yeah. Format type of Date is DateTime as per formatting option under Modelling Tab.
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
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.