Are your dates stored as strings or as the timestamp type? Please note that both approaches would work, however you will need to check your between clause. Lets take an example.
Supposing your date column is stored as a string or ABC type.
You would use the following syntax to check for a range comparison:
map(between(START_TIME_convertFromUnixTS, "2014-03-12", "2014-03-14"))
But if your date was stored as a timestamp as shown here:
and you were to use the above comparison, it would not work as the START_TIME_convertFromUnixTS is represented as 2014-03-13T00:00:00.000Z. You will need to convert the column back to a string and cut the portion starting with "T". An example is shown below:
map(between(cut(string(START_TIME_convertFromUnixTS),1,"T"), "2014-03-12", "2014-03-14"))