It was great to find the DateTimeTrim function when trying to identify future periods in my data set.
It would be even better if in addition to the "firstofmonth" , "lastofmonth" there could be "firstofyear", "lastofyear" functionality that would find for instance Jan, 1 xxxx plus one second and Jan, 1 xxxx minus one second. (Dec, 31 xxxx 12:58:59) respectively.
I'm not sure if time down to the second would even be needed but down to the day period.
DTT menu