Current Month count

[#1]

Data

Ref      ID           Date                               Type          Department

01        554         01/10/2015 09:51:58         Call           E  

02        554         02/10/2015 10:30:02         Call           D

03        333         02/12/2015  11:00:00        email         E

10        554         01/12/2015 09:51:58         Call           E 

11        652         02/12/2015 10:30:02         Call           F

12        652         02/12/2015  11:00:00        Call           F

I wish to create and expression:

Count of "Ref" for the **current month** where the the type is "call"

My result should be "3"

However, I still want to use my selection box for department.

Can anyone advise what expression to use ?

Thank you

[tamilarasu · Accepted solution]

Fine . Are you sure that your createdOn field format is DD/MM/YYYY hh:mm:ss??

If yes, then try below

Date(Date#(Trim(CreatedOn),'DD/MM/YYYY hh:mm:ss'),'MMM') as Month;

Else you need to alter the Date# function to CreatexOn  field format. Let me know.

[#3]

Appreciate your help.

[#4]

It worked Balraj - thank you.

However, please can  you breakdown the expression with comments to tell me what each

part is doing so I can understand what it is doing ?

[tamilarasu]

Happy to help you..