Date.EndOfQuarterDate.EndOfQuarter

SintaxeSyntax

Date.EndOfQuarter(dateTime as any) as any 

SobreAbout

Retorna um valor date, datetime ou datetimezone que representa o fim do trimestre em dateTime.Returns a date, datetime, or datetimezone value representing the end of the quarter in dateTime. As informações de fuso horário são preservadas.Time zone information is preserved.

  • dateTime: Um valor date, datetime ou datetimezone do qual o fim do trimestre é calculado.dateTime: A date, datetime, or datetimezone value from which the end of the quarter is calculated.

Exemplo 1Example 1

Localizar o fim do trimestre de 10 de outubro de 2011, 8:00 AM (#datetime(2011, 10, 10, 8, 0, 0)).Find the end of the quarter for October 10th, 2011, 8:00AM (#datetime(2011, 10, 10, 8, 0, 0)).

Date.EndOfQuarter(#datetime(2011, 10, 10, 8, 0, 0))

#datetime(2011, 12, 31, 23, 59, 59.9999999)