How to: |
The DOWK and DOWKL functions find the day of the week that corresponds to a date. DOWK returns the day as a three letter abbreviation; DOWKL displays the full name of the day.
{DOWK|DOWKL}(indate, output)
where:
I6YMD or I8YMD
Is the legacy date in year-month-day format. If the date is not valid, the function returns spaces. If the date specifies a two digit year and DEFCENT and YRTHRESH values have not been set, the function assumes the 20th century.
DOWK: A4. DOWKL: A12
DOWK determines the day of the week that corresponds to the value in the HIRE_DATE field and stores the result in a column with the format A4.
DOWK(HIRE_DATE, 'A4')
For 80/06/02, the result is MON.
For 82/08/01, the result is SUN.
iWay Software |