DATECALC() Adds/subtracts days,weeks,months,years to a date DTOW() Converts date to words STOD() Returns date from string in the form YYYYMMDD WOYEAR() Calculates week of the year (# of 7 day periods) DTDIFF() Returns difference between dates DAYSIN() Calculates number of days in a month BOYEAR() Determine beginning of year a date falls in BOM() Calculates beginning of the month date DOYEAR() Calculates day of the year from date SETCENT() Determines if century is on/off WOMONTH() Calculates week of the month (# of 7 day periods) BEGEND() Determines beginning or end of week,month or quarter SET_DATE() Sets and restores date format
Tag Archives: SET_DATE()
SP_SET_DATE
SET_DATE() Short: ------ SET_DATE() Sets and restores date format Returns: -------- <nFormat> => previous SET DATE format 1-5 Syntax: ------- SET_DATE([nFormatNew]) Description: ------------ Return current SET DATE setting <nFormat> and optionally set to new format [nFormatNew] [nFormatNew] = 1 American 2 British/French 3 German 4 ANSI 5 Italian Examples: --------- nOldformat := SET_DATE(5) ** SET TO ITALIAN * code * more code SET_DATE(nOldformat) // restore to prior setting Source: ------- S_SETDAT.PRG