- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you post a your work?
is there any data that shuld match today until 14 months forward?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have to limit the date selection for the next rolling 14 months.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have forecast data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
=if(Date#(LXD ,'DD/MM/YYYY')>Today(),
Date#(AddMonths(Today(),14),'DD/MM/YYYY'),
Date#(LXD ,'DD/MM/YYYY'))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you.How can I put this in set analysis
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Only({<LXD={">=$(vTodayDate)<=$(vRollingNext14MonthDate)"}>}[LXD])
Variables:
vToday = Today()
vRollingNext14MonthDate = AddMonths(Today(),14)
You can use max instead of today()
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where are you trying to limit this? Chart? Script? Is LXD read as date? If it is read as date, what is its format?