 |
|||||
|
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 |
| [SOLVED] Date format HYYMDI | Login/Join |
| Silver Member |
I know there is a lot of information out there and I have reviewed the Using functions manual andndescribing data with Webfocus, but I just can't seem to figure out the easiest way to convert a date format HYYMDI to either YYMD or HYYMDs which is the format most of the tables I use are in. With the HYYMDs format I can change the usage format to YYMD without issue. Here is the format in the the master table. Can someone either direct me to documentation that would show me an example of this or provide an example. I would really like to put the define in the MDF file if possible. Thanks in advance for your help.This message has been edited. Last edited by: <Kathryn Henning>, WEBFOCUS 7.14 WEBFOCUS.8.04 | ||
|
| Expert |
Hi Cathy, If you have dev studio then you should be able to locate the Functions help file under ...srv80\home\doc\dmfunc.chm. There is also a PDF version in the same location. I have this as a shortcut on my desktop. The equivalent location on the server should also contain these files. Once you've got that or the function to search on is HDATE, this will convert any date-time format to a date format. Good luck T
| |||||||||
|
| Silver Member |
Thank you Tony. I don't know how many times I used the HDATE function (because that what I figured) but it wasn't working. Guess it was the developer that wasn't working right today  Thanks! WEBFOCUS 7.14 WEBFOCUS.8.04 | |||
|
| Expert |
Hi Cathy, I always double check the syntax in the help file, but don't forget that there is another method in the MFD (MDF "wooden't work ).As I posted on another thread - At many Customer sites I will add additional date columns to SQL data sources to allow both datetime and date formats. All you have to remember with SQL data sources is that the ALIAS MUST be the data source column name, whereas the FIELDNAME can be anything within reason (for this see "Defining data" in a manual for your release). So, you will often see this when I leave synonyms for Customers - -* ATA 2014/05/14 Alternate date column to allow selection via YYMD etc. FIELDNAME=datefield, ALIAS=sql_datefield_name, USAGE=HYYMDS, ACTUAL=HYYMDS, MISSING=ON, $ FIELDNAME=datefield_DMYY, ALIAS=sql_datefield_name, USAGE=DMYY, ACTUAL=DATE, MISSING=ON, $ T
| |||||||||
|
| 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 |