 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Calendar Issue | Login/Join |
| Platinum Member |
I was looking for some more references about the calendar used on the launch page of WF. The issue we are having is that the calendar sends dates in the format "yy/mm/dd" ect, with the "/" sepereating months,days,years. The problem with that is the .fex stores dates in the format I6YMD "YYMMDD." So the report will display the date properly "yy/mm/dd" but will not work with the calendar control when being passed to the report. If we input dates into the calendar inputbox manually "yymmdd" it passes to the report just fine. Anyone else have similar problems or know where I can get a solution to this? dev: WF 7.6.5 w/IIS + Tomcat prod: WF 7.6.5 w/IIS + Tomcat | ||
|
| Expert |
Eric, I have seen the js module savevalues() affect one calendar control by removing the slashes but am not sure if it affects more than one - it should do as it performs a "for" section using document.getElementsByTagName("INPUT"). Just call it in your form tag as onSubmit="SaveValues();" T
| |||||||||
|
| Virtuoso |
If this is not a Focus file, just change the USAGE in the master file to YMD. Then your slashes will be fine. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Platinum Member |
dhagen, i actually have a define setup in the .fex file to change the format from our as400 field to YMD and when I run the .fex itself it displays as yy/mm/dd, the ibiformat in the calendar control is set as YMD as well so the usage is set properly on both ends. Tony, do I have to set up the saveValues js module in the html? Do you have an example of some sort I can follow? dev: WF 7.6.5 w/IIS + Tomcat prod: WF 7.6.5 w/IIS + Tomcat | |||
|
| Expert |
Eric, If you have set=up your launch page in resource layout painter then the JS comntaining the function should have been added for you. It resides in ibirls.js. You should be able to add the onLoad call to your form tag and it "should" be there for you. T
| |||||||||
|
| Platinum Member |
I tried adding that and it still functions the same way. I have even tried redefining the amper values in the report itself to YMD format as well as the field it is comparing itself to in the YMD format. It still will not accept dates with the "/"s in them. Anymore suggestions/ideas? dev: WF 7.6.5 w/IIS + Tomcat prod: WF 7.6.5 w/IIS + Tomcat | |||
|
| Virtuoso |
Just out of curiosity, does your where statement have quotes around the parameter? eg: WHERE DATE EQ '&SOME_DATE'; "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |