I'm building a report that will show information for the previous month. Since the data source is MSCRM I have realized that I need to add times in there because if I don't add 11:59pm, the data from the last day of the month is not included in the report. I am using the formula below. I've tested a few different places to add time but have had no success. Can anybody help out? Thanks!
=EOMONTH(TODAY(),-2)+1&".."&EOMONTH(TODAY(),-1)
I'm not familiar with your data source, however I think the problem is an Excel problem. EOMONTH is not designed to return time - only date. You probably need to add the TIME function to make your dates EOMONTH+TIME
Alternatively, have your tried the Jet formula DATEFILTER function to build your filter? That may be able to work around the need to add the time separately.
=NP("DATEFILTER",EOMONTH(TODAY(),-2)+1,EOMONTH(TODAY(),-1))
There is also a nice solution by Hughes for another member who was looking to add time into their filter:
https://jetsupport.jetreports.com/hc/en-us/community/posts/115008512388-Date-Time-Filter
Once I used your NP function and then added the time filter from the linked post it worked. Thank you!