Date Function in Foxpro

TO ADJUST THE USE FUNCTION SET DATE FORMAT DATE name> NEGARA> COMMAND IN WINDOWS

EXAMPLE
SET DATE BRITIH (DD / MM / YY)
DATE SET AMERICA (MM / DD / YY)
ITALIA SET DATE (DD-MM-YY)
DATE SET GERMAN (DD.MM.YY)
DLL

SO BEFORE YOU DO BETTER enter SETTING THE DATE SET DATE IN ACCORDANCE WITH THE FORMAT IN WANT.
DEFAULT DATE SET FOR HIS DATE (MM / DD / YY)

Show dates
DAY (FIELD) = 1-31
EXAMPLE: DAY (TGLBELI) = 2

Displaying MONTH
MONTH (FIELD) = 1-12
EXAMPLE: MONTH (TGLBELI) = 04

Displaying MONTH OTHER FORMATS
CMONTH (FIELD) = "January - December"
EXAMPLE: CMONTH (TGLBELI) = "May"
NB: "Writing the First Letter of the month should be small and the other in english"

Displaying YEAR
YEAR (FIELD) = 2000
EXAMPLE: YEAR (TGLBELI) = 2010
NB: "Writing must be in writing 4-digit year should not be 2 digits)

Displaying DAY
DOW (FIELD) = 1-7
EXAMPLE: DOW (TGLBELI) = 1
NB: "1 = Sunday, 2 = Monday, 3 = TUESDAY, DST")

Showing ANOTHER DAY FORMAT
CDWO (FIELD) = "Sunday - Saturday"
EXAMPLE: CDOW (TGLBELI) = "Monday"
NB: "The writing on the first letter of other minor in english)

Displays date and MONTH (date 5 months 5)
o EXAMPLE: DAY (TGLBELI) = 5 AND MONTH (TGLBELI) = 5

Displays date and MONTH and YEAR (date 5 years 5 months 2010)
EXAMPLE: DAY (TGLBELI) = 5 AND MONTH (TGLBELI) = 5 AND YEAR (TGLBELI) = 2010

Displaying 5 UP TO DATE DATE 15 (December 5-15)
EXAMPLE: DAY (TGLBELI)> = 5 AND DAY (TGLBELI) <= 15

Displaying 5 UP TO DATE TO DATE MAY 15 (day 5-15 in 5)
EXAMPLE: DAY (TGLBELI)> = 5 AND DAY (TGLBELI) <= 15 AND MONTH (TGLBELI) = 5
Displaying DATE OF BIRTH DAY YOU (birth date: 10 month 08 year 1990)
EXAMPLE: CDOW (CTOD ("10-08-1990"))

CTOD (Charakter To Date)
DTOC (Date To Charakter)

0 komentar:

Post a Comment