Forum Discussion
Berrcikk
2 years agoFrequent Visitor
Group by Date, without Timestamp
Hi all, I'm experiencing a problem with grouping data, which contains also timestamp. Currrent situation is presented below, as you can see, data is not summed up for the same day, due to having tim...
Berrcikk
2 years agoFrequent Visitor
Hi rajendraongole1 thanks for your response, however as I mentioned, I get the error that the column I'm referring to (with .[Date]), doesn't contain any date, alhotugh this column is set up to Date format.
rajendraongole1
2 years agoSuper User
Hi Berrcikk - sty is any language-specific abbreviation? is that a month?
if yes, we have to do in query editor with corresponding months for all 12 months and bring the date format with some other approach.
check it.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!