topic Re: How to find current week's corresponding value(count) from a datefield(G_Date) column? in App Development

How to find current week's corresponding value(count) from a datefield(G_Date) column?

MDC — Wed, 25 Mar 2020 07:47:54 GMT

I have 4 columns as below.
G_Date
2020-03-24 00:00:00:000000
2020-03-23 00:00:00:000000
2020-03-22 00:00:00:000000
2020-03-21 00:00:00:000000
.
.and so on...

F_Week
52
51
50
49
.... and so on the for every year..

F_Year
2020
2020
2019
2018
... and so on...

Count
30
40
50
20
.... and so on

I need the count for the current week.
how do i calculate it? can it be achieved from 'G_Date' field?

Re: How to find current week's corresponding value(count) from a datefield(G_Date) column?

Mauritz_SA — Wed, 25 Mar 2020 11:26:18 GMT

Hi @MDC

I assume you want to Sum the counts for the current week. Then you can use the following expression:

Sum({<G_Date = {'=WeekName(Date#(Left(G_Date,10),''YYYY-MM-DD''))=Weekname(Today())'}>} Count)

Hope this helps.

Regards,

Mauritz

Re: How to find current week's corresponding value(count) from a datefield(G_Date) column?

lorenzoconforti — Wed, 25 Mar 2020 14:05:48 GMT

What are you trying to count? The number of days in the current week?

Re: How to find current week's corresponding value(count) from a datefield(G_Date) column?

MDC — Wed, 25 Mar 2020 14:51:22 GMT

Sum of 'count' for the current week.

Re: How to find current week's corresponding value(count) from a datefield(G_Date) column?

Mauritz_SA — Wed, 25 Mar 2020 14:57:39 GMT

Hi @MDC

Did you try Sum({<G_Date = {'=WeekName(Date#(Left(G_Date,10),''YYYY-MM-DD''))=Weekname(Today())'}>} Count)?