Group by Date shows timestamp in query

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Group by Date shows timestamp in query

Post by swiftinitpvtltd »

When I do Group by Date it also shows timestamp in query grouped row. I want to show date only-
mm/dd/yyyy
row1
row2

but it shows
mm/dd/yyyy with time stamp
row1
row2
How to achieve this via settings?
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Group by Date shows timestamp in query

Post by Jaymer »

I had to have a string field that was a calculation of the date part only. Then I group up on that field
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Post Reply