Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesIt 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.