YEAR, MONTH, DAY, DAYOFWEEK, QUARTER

Modified on Mon, 3 Jun at 3:29 PM

Introduction

Returns the minute component of a specific time, in numeric format.


FORMULAYEAR(datetime_col)
EXAMPLE FORMULAYEAR(datetime_col)
EXAMPLE INPUT2021-04-22 1:02:03
EXAMPLE OUTPUT2021


Sample Usage


Valid ExamplesInvalid Examples
YEAR(datetime_col)YEAR(number_col)

YEAR(text)col)


Notes

  • Must be a Date data type to work


See Also


Still having issues? Contact us at support@gigasheet.com

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article