The DOY function accepts a numeric representation of date and time and returns a number corresponding to the day of the year.
The DOY function has the following format:
DOY(date_time)
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.
The DOY function returns a number from 1 to 366.
Return_value=DOY(1024804800)
Return_value=173
Copyright © 2010 CA. All rights reserved. | Email CA about this topic |