Search the Community
Showing results for tags 'date range'.
-
Is it possible: 1. to grey out or not display dates before today 2. before a certain date in the past 3. after a certain date in the future in the popup calendar? If so, any pointers would be appreciated. Many thanks
-
Good Morning, I'm need the sum of a 'paymentdue' field based on the date range (criteria) selected by the end-user. I'm currently using a sql select statement which is providing the grand total on the details page (formatted for use as the invoice). The sql statment is providing the grandtotal without any date criteria. I need the grand total to change (increase amount or lessen amount) based on the end-user's date range selections. Current Formula used in calculated field on details page: select sum(PaymentDue) from Test_Table where Name=target
- 1 reply
-
- calculation
- sum
-
(and 5 more)
Tagged with:
-
I created a datapage that allows a user to search for information based upon a date range. For begin date I used "Greater than or equal to" and for end date I used "less than or equal to". Here is an example of a search that does not yield an accurate response. I enter the following information as my search parameters: Begin Date: 12/15/2014 End Date: 12/16/2014 The system will return only the records dated 12/16/2014. However there are records dated 12/15/2014 that are not returned. I double checked to make sure that the data resides in my table and it does with the correct date in