Generating counts of dates | Community
Skip to main content
R
Raaghuik1996
Level 2
March 18, 2020
Solved

Generating counts of dates

  • March 18, 2020
  • 2 replies
  • 3293 views

Hi,

 

I have queried delivery logs based on a particular delivery & I have got the necessary output in the temp worktable....now I need to get the count of same dates like in the worktable attached below there are two dates 2nd Mar and 3rd Mar both repeated many times now I want to get like no. of 2nd Mar which is repeated and same for 3rd mar aswell.

Need some help here....Group by not working

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by saikatk2447661

Use a query block and add two columns like this:

 

And in advanced parameter, check the 4th box.

2 replies

anupk2111
anupk2111
Level 2
March 18, 2020

Hi @raaghuik1996 

 

You can use the DateOnly () function to create a temp field which does not gives you the full time stamp but just the date. You can work with the new date field to see the distribution of the dates. 

 

Thanks,

Anup

saikatk2447661
saikatk2447661Accepted solution
Level 4
March 18, 2020

Use a query block and add two columns like this:

 

And in advanced parameter, check the 4th box.

Terms & ConditionsAccessibility statement

Loading footer...