Does anyone know of a utility which can be used to determine which day of the week a date falls on. I am using revelation 3.1. Please E-mail me at [email protected] with suggestions.
You can convert MM/DD/YY or MM/DD/YYyY dates to day of the week by first converting to internal format using RBasic as follows:
*
DAYNAMES$=Sun":@fm:"Mon":@fm:"Tues"…..etc.
INTERNAL_DATE$=ICONV(INPUT_DATE$,"D") ; * you provide means of inputing date through MSG or passed parameters
DATE_NAME$=DAYNAMES$
* return date_name$ to calling program or MSG output
Hope this helps!
There is a www page here that explains the formula to calculate what day (sun…sat) a given date has/will fall on.
John Revelation