Tag Archives: EOY

EoQ()

Posted on by vivaclipper

EoQ()

Date of end of quarter

Syntax

       EoQ( [<dDate>] ) -> dDateEndOfQ

Argument

[<dDate>] Date to find end of quarter, default is DATE()

Returns

<dDateEndOfQuarter> Date of end of quarter containing given date

Example

       PROC MAIN()
              SETMODE( 25, 80 )
              CLS
              SET DATE GERM
              SET CENT ON
              ? "Today is ", DATE()
              ? "Last day of this quarter
              ? "Days remaininng in the cu
              ?
              WAIT "EOF EOQ.prg"
           RETURN // MAIN

Compliance

EOQ() is compatible with CT3’s EOQ().

Platforms

All

Files

Source is datetime.prg, library is libct.

See also

BOM(), EOM(), BOQ(), BOY(), EOY()

EOM()

Posted on by vivaclipper

EOM()

End Of Month

Syntax

       EOM( [<dDate>] ) -> <dDateEndOfMon

Argument

[<dDate>] Date to find last day

Returns

<dDateEndOfMonth> Last date Of Month

Examples

       SET DATE ANSI
       ? EOM( hb_SToD( "20000101" ) ) // -> "2000.01.31"
       ? EOM( hb_SToD( "20000201" ) ) // -> "2000.02.29"
       PROC MAIN()
            SETMODE( 25, 80 )
            CLS
            SET DATE GERM
            SET CENT ON
            ? "Today is ", DATE()
            ? "Last day of this month ", EOM()
            ? "Remaining days in the current month:", EOM() - DATE() 
            ?
            WAIT "EOF EOM.prg"
         RETURN // MAIN
/*
Today is : 04.07.2013
Last day of this month : 31.07.2013
Remaining days in the current month: 27
EOF EOM.prg
*/


Compliance


EOM() is compatible with CT3’s EOM().


Platforms


All


Files


Source is datetime.prg, library is libct.


See also


BOM(), BOQ(), EOQ(), BOY(), EOY()



        
    
			

	
	



		
			


	

		
DOY()


		

		Posted on  by vivaclipper		

	


		

		
DOY()


 Determines the day of the year for a specific date




Syntax


       DMY( [<dDate>] ) -> nDayOfYear


Argument


<dDate> Designates which date to use to calculate the day of the year. The default is the system date.


Returns


DOY() returns a calendar day number that specifies which day of the year <dDate> represents.


Description


Determines the day of the year for a specific date if dDate is invalid, returns 0 If you frequently work with time periods, then this function is quite useful. DOY() lets you assign a calendar day number to a date that relates to the beginning of the year.


Note


. When no date is specified, DOY() uses the system date. January 1 is always 1, December 31 is 366 in a leap year; otherwise, it is 365. An empty date returns a 0 result.


Example


      ? DOY( hb_SToD( "20000131" ) ) // -> 31
      ? DOY( hb_SToD( "20000220" ) ) // -> 51


Compliance


DOY() is compatible with CT3’s DOY().


Platforms


All


Files


Source is dattime2.prg, library is libct.


Seealso


WOY()

			

	
	



		
			


	

		
BoY()


		

		Posted on  by vivaclipper		

	


		

		
BoY()


 Date to find first day of year, default is DATE()




Syntax


       BoY( [<dDate>] ) -> dDateBeginOfYear


Argument


[<dDate>] : Date to find first day of year, default is DATE()


Returns


<dDateBeginOfYear> : Beginning date Of year of given date


Example


       PROC MAIN()
          SETMODE( 25, 80 )
          CLS
          SET DATE GERM
          SET CENT ON
          ? "Today is :", DATE()
          ? "Date of first day of this year :", BOY()
          ? "Days elapsed in the current year:", DATE() - BOY()
          ?
          WAIT "EOF BoY.prg"
       RETURN // MAIN


Compliance


BoY() is compatible with CT3’s BoY()


Platforms


All


Files


Library is hbct.


See also


BoM(), EoM(), BoQ(), EoQ(), EoY()

			

	
	



		
			


	

		
BoQ()


		

		Posted on  by vivaclipper		

	


		

		
BoQ()


 Date of beginning Of quarter containing given date




Syntax


       BoQ( [<dDate>] ) -> <dDateBeginOfQuarter>


Argument


[<dDate>] : Date to find Begin Of Quarter, default is DATE()


Returns


<dDateBeginOfQuarter> : Date of beginning Of quarter containing given date


Example


       PROC MAIN()
            SETMODE( 25, 80 )
            CLS
            SET DATE GERM
            SET CENT ON
            ? "Today is :", DATE()
            ? "Beginning day of this quarter :", BOQ()
            ? "Days elapsed in the current quarter :", DATE() - BOQ()
            ?
            WAIT "EOF BOQ.prg"
         RETURN // MAIN


Compliance


BoQ() is compatible with CT3’s BoQ()


Platforms


All


Files


Library is hbct.


See also


BoM(), EoM(), EoQ(), BoY(), EoY()

			

	
	



		
			


	

		
BoM()


		

		Posted on  by vivaclipper		

	


		

		
BoM()


 Beginning date Of Month of given date




Syntax :


      BoM( [<dDate>] ) -> <dDateBeginOfMonth>


Argument :


[<dDate>] : Date to find first day of month, default is DATE()


Returns :


<dDateBeginOfMonth> : Beginning date Of Month of given date


Examples


       PROC MAIN()
          SETMODE( 25, 80 )
          CLS
          SET DATE GERM
          SET CENT ON
          ? "Today is :", DATE()
          ? "Date of first day of this month :", BOM()
          ? "Days elapsed in the current month:", DATE() - BOM()
          ?
          WAIT "EOF BOM.prg"
       RETURN // MAIN


Compliance


BoM() is compatible with CT3’s BoM().


Platforms


All


Files


Library is hbct.


See also


EoM(), BoQ(), EoQ(), BoY(), EoY()

			

	
	



		
			


		
			


	

		
Date & Time Functions


		

		Posted on  by vivaclipper		

	


		

		
Date & Time Functions






ADays
Returns an array with the days names




AddMonth
Adds or subtracts months to/from a date




AMonths
Returns an array with the months names




BOM
Beginning date Of Month of given date




BOQ
Date of beginning Of quarter containing given date




BOY
Date to find first day of year, default is DATE()




CDoW
Converts a date to the day of week




CMonth
Return the name of the month




CToD
Converts a character string to a date expression




CToDoW
Convert name of day of the week to its ordinal number




CToMonth
Convert name of month to its ordinal number




Date
Return the Current OS Date




Day
Return the numeric day of the month




Days
Convert elapsed seconds into days




DaysInMonth
Returns the number of days in month




DaysToMonth
Total number of days from first of Jan to beginning of nMonth




DMY
Returns the date as a string in DD Month YY format




DoW
Value for the day of week




DOY
Determines the day of the year for a specific date




DToC
Date to character conversion




DToS
Date to string conversion




ElapTime
Calculates elapted time




EOM
End Of Month




EOQ
Date of end of quarter




EOY
Last date Of Year




IsLeap
Tests if a specific year is a leap year




IsLeapYear
Checks if the given date is a leap year




LastDayOM
Determines the number of days in a month




MDY
Returns the date as a string in Month DD, YY or Month DD, YYYY




Month
Converts a date expression to a month value




NToCDoW
Find day name by num of day




NToCMonth
Find a month name by the number of month




Quarter
Returns a number equal to the quarter in which a date falls




Seconds
Returns the number of elapsed seconds past midnight




Secs
Return the number of seconds from the system date




SecToTime
Converts seconds into a time string




Time
Returns the system time as a string




TimeValid
Determines whether a specified time is valid




TimeToSec
Calculates the seconds since midnight




WaitPeriod
Pauses a specified time in increments of 1/100 seconds




Week
Returns the calendar week a number




WOY
Gets the week number of the year




Year
Converts the year portion of a date into a numeric value





			

	
	



		
			


	

		
Tools — Date/Time Functions


		

		Posted on  by vivaclipper		

	


		

		
Introduction Date/Time Functions
ADDMONTH()   Adds or subtracts months to/from a date
BOM()        Determines the date of the first day of a month
BOQ()        Determines the date for the beginning of a quarter
BOY()        Determines the date for the beginning of a year
CTODOW()     Converts the day of the week name into a corresponding number
CTOMONTH()   Converts the name of the month into a corresponding number
DMY()        Returns a date in "DD Month YY" format
DOY()        Determines the day of the year for a specific date
EOM()        Determines the date for the last day of a month
EOQ()        Determines the date for the end of a quarter
EOY()        Determines the date for the end of the year
ISLEAP()     Tests if a specific year is a leap year
LASTDAYOM()  Determines the number of days in a month
MDY()        Returns a date in the "Month DD, YY" format
NTOCDOW()    Changes the number of a weekday into a weekday name
NTOCMONTH()  Changes the number of a month into a month name
QUARTER()    Determines the quarter in which a specific date lies
SECTOTIME()  Converts seconds into a time string
SETDATE()    Sets the system date
SETTIME()    Sets the system clock
SHOWTIME()   Continuously displays the time at desired screen position
STOD()       Converts an ANSI date string into Clipper format
TIMETOSEC()  Calculates the seconds since midnight
TIMEVALID()  Determines whether a specified time is valid
WAITPERIOD() Pauses a specified time in increments of 1/100 seconds
WEEK()       Returns the calendar week for a date
WOM()        Returns the week within a month.