Monday filter

Jet Reports Historic Posts

April 27, 2016 15:42

None

Hi guys,

I'm looking for a way to create a filter containing all Mondays in a specified date range (like from 2010 to 2016) . Is there any way to use the NP("Dates") function for this combined with WEEKDAY from excel?

Any help would be much appreciated :)

Date Votes

1 comment

0

Jet Reports Historic Posts April 28, 2016 06:59

Assuming that you have a bunch of records with the date in them, and you only want to return the ones which fall on Monday then you could do something like this:

NL("Rows","MyTable",,"Field1","Filter","MyDateField",NP("DateFilter","Date1","Date2"),"=WEEKDAY(NF(,""MyDateField""))","2")

Comment actions Permalink

Please sign in to leave a comment.