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>,

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

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!

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