putting in logic to make sure that when using range or exactDate types
that we always use beginning of day and end of day
adding big decimal template