Create field DATE - 3 Months ago

Elastic Stack Elasticsearch
1

In an index, I have a field called date (format: YYYY-MM-DD HH:MM:SS)

How can I create a new field "called Date3M) to have the same date but 3 months ago ?
Example: Date: 2016-07-05 02:30:54
Date3M: 2016-04-05 2:30:54

Thanks!

2

If you need to store the field I think you have to use any kind of scripting.

3

there is no other solution with Lucene ?

4

I don't think so, maybe someone else have any ideas...?

What do you want to achive? You probably can do the date math in your injection pipeline...

5

In this case you can use script field in your query

"script_fields" : { "myField" : { "script" : "doc['my_field_name'].value * 2" } }

Where you can define what should happen, let's say that you storing date in timestamp then you can do this:

"script_fields" : {
"date3m" : {
"script" : "doc['date'].value - 32460*60"
}
}