In LB4 DATE$ provides only three formats for returning the date as a string:
Code: print date$("mm/dd/yyyy") ' 01/30/2012
print date$("mm/dd/yy") ' 01/30/12
print date$("yyyy/mm/dd") ' 2012/01/30
LBB is more flexible, it will return the date in any format that can be constructed from the following elements, in any order, separated by '/' or '-':
| d | Day of month as digits with no leading zero for single-digit days. |
| dd | Day of month as digits with leading zero for single-digit days. |
| ddd | Day of week as a three-letter abbreviation. |
| dddd | Day of week as its full name. |
| m | Month as digits with no leading zero for single-digit months. |
| mm | Month as digits with leading zero for single-digit months. |
| mmm | Month as a three-letter abbreviation. |
| mmmm | Month as its full name. |
| y | Year as last two digits, but with no leading zero for years less than 10. |
| yy | Year as last two digits, but with leading zero for years less than 10. |
| yyyy | Year represented by full four digits. |
So for example:
Code:print date$("dddd dd-mmmm-yyyy") ' Sunday 30-January-2012
Richard.