Please have a look at the attached file. I have two tables: Proyect and Proyect Ledger. Both have date vaules in the table: Proyect start and enddate and posting date in the proyect ledger table. What I need is the following: I need to be able to select any given date (inputbox or slide calender??) and that should be getting me all active proyects at that date.
Similar functionality you can see in the attachment for the current date (selecting Active in 'Active at current date'). Can you please help me out to change that current date into a date that I can modify into any given date (past or future).
The Calender table and Active table are added here to show what I need; They do not need to be in the final solution.
