Max Date should not be greater than Today

[Anonymous]

Hi

I want to create a variable where the max date should not be greater than today.  Currently I have a max date as 31 Dec 2017.

Formula for Max Date:

=Date(max(Date),'YYYY/MM/DD')

Here is my variable.

=if(num(max(Date))>num(Today()), Null(),Date)

I can't seem to get it right.

Thank you

Kind regards

Nayan

[Anil_Babu_Samineni]

Let's assume, your variable looks like below, You may don't have issue with Date formats

LET Var = Date(Max(Date),'YYYY/MM/DD')

And then condition should be like this

If($(Var) > Date(Today(), 'YYYY/MM/DD'), Null(), Date)

[tresesco]

If you are expecting the variable to return the max date, try like:

=if(max(Date)>Today(), Null(),Date(Max(Date)))

Or, simpler

=if(max(Date)<=Today(),Date(Max(Date)))

[Kushal_Chawda · Accepted solution]

=if(floor(max(Date))>floor(today()), floor(today()),max(Date))

or

=if(floor(max(Date))>floor(today()), null(),max(Date))

[Anonymous]

Hi Anil

Thank you for your response.  Will try it out and let you know.

Kind regards

Nayan

[Anonymous]

Hi Anil

I've tried your formula, however i still get a blank.

kind regards

Nayan

[Kushal_Chawda]

have you tried my solution?

[jmvilaplanap]

You can use the RangeMin function, this will return the minimum value, for example

=RangeMin(max(Date), Today())

[Anil_Babu_Samineni]

You mean to say, Are you trying this expression in Variable?

[antoniotiman]

Hi,

try

=Max({<DateField={'<=$(=Date(Today()))'}>} DateField)

Regards,

Antonio