EoQ()

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()

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()

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()

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()

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()

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()