Set analysis compare dates

[#1]

Hello

I need to count the days selected until today.

I want to do something like this:

COUNT(DISTINCT {$<Fecha={<today()}>} Fecha)

But it goes wrong.

"Fecha" is a field in data format. If I show this field for today i see 42110,

Could someone tells me how must i do?

Thanks,

Fernando

[swuehl]

Try a Dollar sign Expansion and search in your set modifier:

COUNT(DISTINCT {$<Fecha={"<$(=num(today()))"}>} Fecha)

[buzzy996]

u can try this,

=networkdays( Fecha,today())

Fecha* should be date field

[#4]

Hi swuehl;

This doesn't go well.

No t return the true result 😞

Thanks

[#5]

Hi Shiva;

The expression goes well but I need another thing. I need do it in set analysis.

Thanks a lot. I don't knew the networkdays function 🙂

[buzzy996]

it's calculate accurate days in this case,and we can also use in different purpose to exclude holidays in other cases..

[buzzy996]

if ur happy with tht...u can mark as correct

[#8]

I need that someone tells me how do the same with the set analysis.

I mark the like  button

[Anonymous · Accepted solution]

Hi, Fernando.

Try  this

create two variables

MinDate= min(Fecha)

MaxDate= Today()

Your  Expression:

=count({$<Fecha={"<=$(MaxDate)>=$(MinDate)"}>} DISTINCT Fecha)

[#10]

Hi Jannet;

I have to learn more about the use of $(...).

The solution you gave me is just what I needed.

Before I wrote here I tried to do this:

COUNT(DISTINCT {$<Fecha={<today()}>} Fecha

The correct expression is:

count({$<Fecha={"<$(=Today())"}>} DISTINCT Fecha)

I know is better to use variables but I wanted understand why didn't goes well the expression

Thanks a lot

Fernando