Date Picker
One of the items that the IDEAScripting dialog lacks is a date picker. I recently saw a post on the IDEA forum that they had the script for one but for some strange reason weren't releasing it on the scripting section, so I decided to try and create a date picker for my use and anyone else that wants to use it.
The attached script has the code for the date picker along with an example of how to use it with a dialog that asks for the user to enter a date.
When you start up the example script you will have a dialog with two edit boxes where the user can enter a date:
To access the date picker in this instance you would click on the Calendar button and another dialog will open on top of the first dialog.
Using the date picker you can select your date, the < and > will move you through the months. Clicking on the Current Date button will take you back to the current date. There is a drop down that shows the current year and 5 years forward and 5 years back. So you can move through the years if 5 year increments.
Once you select a date the date picker dialog will close and the date will be inserted in the edit box.
The code allows for multiple date edit boxes but each one would need a separate button. The code was been commented and if you have any questions or comments please let me know. You can download the code here.
Updated March 4, 2015 - Added functionality so the script should work with different regional settings and date formats.
It is actually there but just
It is actually there but just hidden in the text. Here is the link http://ideascripting.com/sites/default/files/isDatePicker%2004032015.iss
Substitute the dates captured in the form. I have an oracle data
I have an oracle database, and I need to extract the records from a table with the odbc d idea built in. the question is how do I substitute those form dates in the odbc import.
example
bName = "tcp_xxxxx.IMD"
Client.ImportODBCFile "" & Chr (34) & "F" Chr (34) & "." & Chr (34) & "tcp_xxx" & Chr (34) & "", dbName, FALSE, "; DSN = BLH9I.world; UID = xxxx PWD = _IDEA9xx_xx DBQ = BLH9I.WOR; DBA = BLH9I.WORLDA; DBA = T; EXC = F; FEN = T; QTO = T; FRC = 10; FDL = 10; LOB = T; RST = T; BTD = F; BNF = F; BAM = IfAllSuccessful; NUM = NLS; DPM = F; MTS = T; MDI = F; CSR = F; FWC = F; FBS = 00; TLO = O; MLD = 0; ODA = F; "," SELECT * FROM TCP_xxxxx where TMO_FECHC> = '20210801' and TMO_FECHC <= '20210930' AND TMO_CODMOD = 4 AND TMO_MODO = 'N' "Client.OpenDatabase (dbName.
dlgMenu dialog box from the scripts isDatePicker
hello,
hello, in this script that asks for the dates is the dlgMenu dialog box, I want to insert several radio buttons to make a selection and according to the option chosen, execute a script, it asks me is, where should I place the codes to perform the validation of the option that the user selected? In this scripts you could place me a guide example. http://ideascripting.com/sites/default/files/isDatePicker%2004032015.iss
Hello. I'm sorry to bother,
Hello. I'm sorry to bother, but the download link is not available. Thanks.