topic Re: Count based on a date condition in App Development

Count based on a date condition

Wed, 22 Dec 2021 15:42:54 GMT

I want to count all the tickets that were created yesterday using the column CREATED DATE

Please send the expression, I am thinking of using the today()-1 function

Re: Count based on a date condition

MK_QSL — Fri, 14 Nov 2014 19:50:41 GMT

Write below just below [Created Date] in script

Date(Floor(TimeStamp([Created Date])),'DD/MM/YYYY') as CreatedDate,

Now use below Expression in Front End

=COUNT({<CreatedDate = {'$(=Date(Today()-1),'DD/MM/YYYY')'}>}Distinct Ticket#)

Re: Count based on a date condition

Sat, 15 Nov 2014 04:48:57 GMT

Thanks Manish, I followed your instructions, however the value is always 0.00 when I see some records from the previous day. What am I doing wrong?

LOAD

"Incident Number",

"Destination System Reference Number",

"Date Occurred",

"Incident Created Date",

Date(Floor(TimeStamp([Incident Created Date])),'DD/MM/YYYY') as CreatedDate,

"Last Modified Date",

COUNT({<CreatedDate = {'$(=Date(Today()-1),'DD/MM/YYYY')'}>}Distinct [Incident Number])

Re: Count based on a date condition

Sat, 15 Nov 2014 07:42:50 GMT

hey jose,

why don't you try

vDate=date(today()-1)

count({<createdDate={"$(vDate)"}>}distinct [incident number])

cheers,

kunal bhattacharjee

Re: Count based on a date condition

MK_QSL — Sat, 15 Nov 2014 08:00:18 GMT

let me know the date format of Incident Create Date

Re: Count based on a date condition

Sat, 15 Nov 2014 18:15:22 GMT

Thanks Kunal and Manish, I tried the vDate and it is working now, MUCHAS GRACIAS!

Re: Count based on a date condition

Mon, 17 Nov 2014 06:22:12 GMT

hey jose,

can you please mark the correct answer and helpful answer and close the thread? that would be helpful!

cheers,

kunal bhattacharjee