Previous Topic: DOW Function--Return Day of Week

Next Topic: ENUMERATE Function--Test Set Elements

DOY Function--Return Day of Year

The DOY function accepts a numeric representation of date and time and returns a number corresponding to the day of the year.

Syntax

The DOY function has the following format:

DOY(date_time)

Parameters

The DOY function accepts the following parameter:

date_time (number)

Specifies the date and time as the number of seconds that have passed since January 1, 1970. If the date is invalid, the function returns -1.

Return Value

The DOY function returns a number from 1 to 366.

Example

Return_value=DOY(1024804800)
Return_value=173

More information:

DAY Function--Return Day of Month

DOW Function--Return Day of Week


Copyright © 2010 CA. All rights reserved. Email CA about this topic