---
schema_version: "1"
id: 72269a630859f64f395bfc9713b7dfdbddb31fc50e758dc60a410f3525f3de44
title: year_last_day(date)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-functions-timezone-year-last-day.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-year-last-day.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 7604e1578713a7dc4313d9e3fc3409c59175ef65a6ccbf9df3011e68ad8e8802
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# year_last_day(date)

Returns the date of the last day of the year for a specific date.

```nolang
q = foreach q generate year_last_day('BillDate') as "Year Last Day";
```

**note:** This function always returns December 31. It’s included for uses such as finding the number of days to the year end and for use in a specific locale.