# Error in comparing date type fields on logstash

**URL:** <https://discuss.elastic.co/t/error-in-comparing-date-type-fields-on-logstash/234853>\
**Category:** Logstash\
**Created:** [May 29, 2020, 2:57am UTC](https://discuss.elastic.co/t/error-in-comparing-date-type-fields-on-logstash/234853 "2020-05-29T02:57:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ed2050](https://avatars.discourse-cdn.com/v4/letter/e/8e8cbc/32.png) [@ed2050](https://discuss.elastic.co/u/ed2050)\
**Post date:** [May 29, 2020, 2:57am UTC](https://discuss.elastic.co/t/error-in-comparing-date-type-fields-on-logstash/234853/1 "2020-05-29T02:57:09Z")

</div>

Hi.

I have the following error when comparing two fields of date types:

An unexpected error occurred! {:error=\>#\<NoMethodError: undefined method `>' for nil:NilClass>, :backtrace=>["(eval):81714:in `block in initialize'", "org/jruby/RubyArray.java:1792:in `each'", "(eval):81712:in `block in initialize'", "(eval):81748:in `block in initialize'", "org/jruby/RubyArray.java:1792:in `each'",

The code in the filter looks like this:

```auto
      mutate{replace => {"Timestamp"=>"%{+YYYY-MM-dd}T%{hour}"}}
      mutate { add_field => { "Timestamp19" => "%{+YYYY-MM-dd}T19:00:00" } }
  
  #String to Date TimeStamp
 	 date
		{
			match => ["Timestamp", "ISO8601", "YYYY-MM-dd HH:mm:ss", "YYYY-MM-dd HH:mm:ss ZZZ", "YYYY-MM-dd HH:mm:ss SSS"]
			target => "TimeStamp"
      locale => "en"
  		} 
     

   #String to Date TimeStamp19
 	 date
		{
			match => ["Timestamp19", "ISO8601", "YYYY-MM-dd HH:mm:ss", "YYYY-MM-dd HH:mm:ss ZZZ", "YYYY-MM-dd HH:mm:ss SSS"]
			target => "TimeStamp19"
      locale => "en"
  		}  
     

   #Comparing 
   if [TimeStamp] > [TimeStamp19] {
      mutate { add_field => { "EsMayor" => "SI" } }
   
   }   

```

hour is a source field containing an hour

The two date fields are converted correctly, but the error occurs in the comparison

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 26, 2020, 2:57am UTC](https://discuss.elastic.co/t/error-in-comparing-date-type-fields-on-logstash/234853/2 "2020-06-26T02:57:15Z")

</div>

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