Focal Point
[SOLVED] from date and to date chaining

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7447034196

July 21, 2019, 04:18 PM
getit
[SOLVED] from date and to date chaining
I have two simple YYMD Calender dates on HTML. From Date and To Date.
I would like to populate the TO date as what ever the user selects in From date + 31 days.
I have tried chaining ,but I am getting error. How do you achieve this?

This message has been edited. Last edited by: FP Mod Chuck,


App Studio Version 8202
windows Platform
SQL Server 2008/2012
July 22, 2019, 08:39 AM
MartinY
Up to me, I would not create a date picker (calendar control) for the "To date" since, as you stated : "I would like to populate the TO date as what ever the user selects in From date + 31 days"
So, no need to have a date control for that. Except if you want to give the ability to the user to change that "To date" once you assigned it to 31 days later …?

Add an onChange event to the "From date" picker then in JS calculate the "To date" and display in a disable (write protected) text box if necessary.
I'm saying "if necessary" because if the user doesn't have the ability to change to "To date" why would you want to have it displayed on the selection screen ? May only be displayed on the produced report. Just a thought


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
July 22, 2019, 05:22 PM
getit
Yes, User can change this if needed. I did create it using the Javascript. Thanks.


App Studio Version 8202
windows Platform
SQL Server 2008/2012
July 23, 2019, 09:39 AM
MartinY
My pleasure
Please update your first post then add [SOLVED] at the beginning of the subject


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007