I need to format dates into Month Year, Week ending, etc. They are used in a report and does not sort well if the date is a character field. It needs to be a date field.
A document would be helpful.
Thank you,
Cathy
DEFINE VARIABLE dtMyDate AS DATE INITIAL TODAY NO-UNDO.
DEFINE VARIABLE dtSrtOfYear AS DATE INITIAL 01/01/2011 NO-UNDO.
MESSAGE
MONTH(dtMyDate) SKIP
YEAR(dtMyDate) SKIP
INTERVAL(dtMyDate,dtSrtOfYear, 'weeks') SKIP
dtMyDate + (7 - WEEKDAY(dtMyDate))
VIEW-AS ALERT-BOX INFO BUTTONS OK.