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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
How do I use EDIT function to rearrange date from mm/dd/yyyy to yyyy-mm-dd? Sometimes, month and/or day could be single digit. I just need it to convert to ISO format. Is there a function that will convert an input date to ISO date format?This message has been edited. Last edited by: djseattle,
This topic has been added to the "iWay Forum" but seems to be a WebFOCUS question. I understand you are new to the Focal Point forum - Welcome! however, you will receive better response if the question is in the right forum.
If this is related to an iWay topic then that is fine. Once you become more familiar with the product(s) then you will get a feel for where the question should be posted.
As far as ISO is concerned please refer to the following link on the IBI TechSupport site.
Add the following to the edasprof.prf or your fex.
SET DTSTANDARD = {OFF|ON|STANDARD|STANDARDU} - description of the options are in the link
For your EDIT of date please refer to the following Focal Point WebFOCUS links:
[Solved] Date Formatting for Calendar For the above link - see the conversation posted on posted June 13, 2012 10:06 AM This provided EDIT reformatting of the date. You will have to ensure it conforms to your date format.
If you have only a single digit then you may need to check for this and then concatenate ('|') the '0' to the first digit.
Hope this helps you out, let us know.
Once you are satisfied with the replies then we also as you to update the subject line Tag your topic with keywords .
Thank you for participating in the Focal Point Forum.
What is the best way to look for single digit? There is no split function so I have managed to do this using EDIT and IF statement. However, the code became very long.