Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Limitation.

I have to limit LXD to catch within nect 14 months from today and I tried below script in list box to test...but its not working..

=IF([LXD] > today() and  [LXD] < addmonths(today(),14),[LXD])

Thanks mmuch.

8 Replies
jpenuliar
Partner - Specialist III

Can you post a your work?

is there any data that shuld match today until 14 months forward?

Not applicable
Author

I have to limit the date selection for the next rolling 14 months.

jonathandienst
Partner - Champion III

Try

=Aggr(If(LXD > Today() And  LXD < Addmonths(Today(), 14), LXD), LXD)

Is LXD a numeric WV date, or is it a string. If the latter, convert this to a date at initial load using the Date#() interpretation function. AddMonths() does not work on a string.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anil_Babu_Samineni

Do you have forecast data?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
el_aprendiz111
Specialist

Hi,

=if(Date#(LXD ,'DD/MM/YYYY')>Today(),

     Date#(AddMonths(Today(),14),'DD/MM/YYYY'),

      Date#(LXD ,'DD/MM/YYYY'))

Not applicable
Author

Thank you.How can I put this in set analysis

neelamsaroha157
Specialist II

Try this

Only({<LXD={">=$(vTodayDate)<=$(vRollingNext14MonthDate)"}>}[LXD])

Variables:

vToday = Today()

vRollingNext14MonthDate = AddMonths(Today(),14)


You can use max instead of today()

sunny_talwar

Where are you trying to limit this? Chart? Script? Is LXD read as date? If it is read as date, what is its format?