Search the Community
Showing results for tags 'date range'.
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
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