If else return scripted field date field

Elastic Stack Kibana
1

Is it possible to do an if else return statement with dates? For example, if the date in the date column is 1/1/21 I want it to return Week 1. I tried doing that below but I am getting the error shown in the screenshot.

Screen Shot 2021-10-13 at 10.52.18 AM
Screen Shot 2021-10-13 at 10.52.18 AM2668×1068 246 KB

2

You need to format your date into a defined pattern using DateTimeFormatter, this is my test using the kibana_sample_data_flights dataset:

GET kibana_sample_data_flights/_search
{
  "size": 5,
  "_source": ["timestamp"],
  "script_fields": {
    "mmddyyy": {
      "script": {
        "source": """
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("MM/dd/yyyy");
dtf.format(doc['timestamp'].value)
        """
      }
    },
    "is08162021": {
      "script": {
        "source": """
String myDate = '08/16/2021';
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("MM/dd/yyyy");
if (dtf.format(doc['timestamp'].value) == myDate){return "yeah, it is " + myDate }
        """
      }
    }
  }
}

image
image1169×638 80.2 KB

More details on how to work with dates on the painless docs:

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.