Within the NL function window, I'd like to have a monthly range, based on two cells that I have within Excel (06/01/2022 - 06/30/2022). How do I put in such a range, within the NL function window?
Date
Votes
3 comments
-
CascadiaDataworks Ideally, date ranges are something that are great for a Report Option that can be changed at runtime since it is rare that you will use the same date range every time you run the report in the future
In this case, dates should be populated in one cell and the NL function references the date range. Dates should be in the format DATE..DATE
As an example, I would put in B3 the value 06/01/22..06/30/22
My NL function might look like NL("Rows", "Sales Invoice Header", "No.", "Posting Date", $B$3)
-
Cat I like to use two date fields - start date (B3) and end date (B4) and put NP("DateFilter", $B$3, $B$4) in B5 and reference the NL function to B5. This way it is easier to enter the date fields.
B3 = 06/01/22 and B4 = 06/30/22 => 06/01/22..06/30/22
B3 = 06/01/22 and B4 = empty => 06/01/22..
B3 = empty and B4 = 06/30/22 => ..06/30/22
B3 = empty and B4 = empty => *
-
CascadiaDataworks That is a great call, Cat! This will help build date ranges so end users don't need to worry about the .. format which they may not be familiar with.
Please sign in to leave a comment.