# Weekyear\_week as scripted field
**URL:** https://discuss.elastic.co/t/weekyear-week-as-scripted-field/117770
**Category:** Kibana
**Created:** [January 31, 2018, 8:59am UTC](https://discuss.elastic.co/t/weekyear-week-as-scripted-field/117770 "2018-01-31T08:59:53Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@jakn](https://discuss.elastic.co/u/jakn)
#### Post date: [January 31, 2018, 8:59am UTC](https://discuss.elastic.co/t/weekyear-week-as-scripted-field/117770/1 "2018-01-31T08:59:53Z")
How do I create a scripted field showing timestamp formatted as 'weekyear\_week'?
The weekyear\_week format is described here:
[https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html#date-math](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html#date-math)
For creating a scripted field containing dayOfWeek in my time zone (CET) I use the following in Kibana 6.
`LocalDateTime.ofInstant(Instant.ofEpochMilli(doc['@timestamp'].value.millis), ZoneId.of('CET')).getDayOfWeek()`
---
### Author:  [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)
#### Post date: [January 31, 2018, 7:34pm UTC](https://discuss.elastic.co/t/weekyear-week-as-scripted-field/117770/2 "2018-01-31T19:34:48Z")
I don't enough about Painless to actually help you out here, but looking at the [API reference](https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-api-reference.html), it seems like you might be able to specify a custom format using the [DateTImeFormatter](https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-api-reference.html#painless-api-reference-DateTimeFormatter).
---
### Author:  [@jpcarey](https://discuss.elastic.co/u/jpcarey)
#### Post date: [January 31, 2018, 8:03pm UTC](https://discuss.elastic.co/t/weekyear-week-as-scripted-field/117770/3 "2018-01-31T20:03:56Z")
I get `Unsupported field: OffsetSeconds"` when trying to use `DateTimeFormatter` on `LocalDateTime`.
This worked ok, although - I haven't really checked if it is correct.
```auto
if (doc['@timestamp'] != null) {
Instant instant = Instant.ofEpochMilli( doc['@timestamp'].value.millis );
ZoneId zoneId = ZoneId.of ( "America/Los_Angeles" );
DateTimeFormatterBuilder builder = new DateTimeFormatterBuilder();
DateTimeFormatter formatter = builder.appendPattern("YYYY'-W'ww").toFormatter();
String formattedDate = formatter.format(
ZonedDateTime.ofInstant ( instant , zoneId )
);
return formattedDate;
}
```
---
### Author:  [@jakn](https://discuss.elastic.co/u/jakn)
#### Post date: [February 9, 2018, 9:38am UTC](https://discuss.elastic.co/t/weekyear-week-as-scripted-field/117770/4 "2018-02-09T09:38:05Z")
> [@jpcarey](#):
>
> if (doc['@timestamp'] != null) {
> Instant instant = Instant.ofEpochMilli( doc['@timestamp'].value.millis );
> ZoneId zoneId = ZoneId.of ( "America/Los\_Angeles" );
> DateTimeFormatterBuilder builder = new DateTimeFormatterBuilder();
> DateTimeFormatter formatter = builder.appendPattern("YYYY'-W'ww").toFormatter();
> String formattedDate = formatter.format(
> ZonedDateTime.ofInstant ( instant , zoneId )
> );
> return formattedDate;
> }
Unfortunately, the output does not comply with the local week definitions.
If time zone is set to "Europe/Copenhagen" in the suggested script then the week changes between Saturday and Sunday although by definition a new week begins on Mondays in Denmark.
> **[Current Week in Denmark - Savvy Time](https://savvytime.com/current-week/denmark)**
>
> Current week number in Denmark. Week rules, Start and End dates, monthly calendar with current week. View current week in any country around the world. How many weeks in a year?
How should the script be adjusted to end up with a week definition valid in the time zone used in the scripted field?
---
### Author:  [@jakn](https://discuss.elastic.co/u/jakn)
#### Post date: [February 19, 2018, 7:17am UTC](https://discuss.elastic.co/t/weekyear-week-as-scripted-field/117770/5 "2018-02-19T07:17:30Z")
Any suggestions?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 19, 2018, 7:17am UTC](https://discuss.elastic.co/t/weekyear-week-as-scripted-field/117770/6 "2018-03-19T07:17:53Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.