Fig1
Contributor III
2020-05-17
04:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show date 12months prior to start date
I would like to display the date 12 months prior to the start date.
Start_New =(">$(=AddMonths(Max(Start_New),-12, 'MMM-YY')"))
am i close????
762 Views
1 Solution
Accepted Solutions
Fig1
Contributor III
2020-06-25
11:55 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
my solution: addmonths(NNAV_StartDate, -12)
687 Views
4 Replies
lironbaram
Partner - Master III
2020-05-17
05:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Start_New ={">$(=date(AddMonths(Max(Start_New),-12), 'MMM-YY'))"}
742 Views
Fig1
Contributor III
2020-05-17
05:52 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This didnt work. I have had a bit of play and came up with this, however it is showing the value as 'zero' and not the date.
Start_New=('$(=date(addmonths(max(Start_New),-12), 'DD-MM-YYYY'))')
736 Views
lironbaram
Partner - Master III
2020-05-17
09:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
do you try this is set analysis
728 Views
Fig1
Contributor III
2020-06-25
11:55 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
my solution: addmonths(NNAV_StartDate, -12)
688 Views