Im not sure if this should be filed under bug or feature request.
The Bug Portion:
The Feature Request:
It seems like it would be really helpful to add in some additional GUI-goodies to handle time and dates. For example, I would love to be able to take two dates and calculate the difference in a custom column. I realize i can do this if the dates are in seconds) but it would still then be in a format different from what I’d like. This would also allow me to use the built in table relationship settings that custom queries do not seem to have access to.
In addition, it would be awesome to be able to Average a time duration like you can with other numbers.
Please let me know if these things already exist and I’m simply using it wrong.