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,
WebFOCUS 8 Windows, All Outputs
April 29, 2016, 08:44 AM
Tamra
Hello 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.
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
April 29, 2016, 01:52 PM
djseattle
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.
WebFOCUS 8 Windows, All Outputs
May 02, 2016, 08:54 AM
jgelona
"What is the best way to look for single digit?"
djseattle, is this a different question than your original? If so, it should be a new topic
Actually there is split function, it is call GETTOK. It "splits" a string based on a search string.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
May 02, 2016, 11:10 AM
djseattle
Thanks everyone for your responses, and helping me find solution.