Currently, the FormatDateTime() function formats a DateTime value based on the specified format, but the result is returned as Text. This requires additional conversions when the value needs to be used in date calculations, sorting, filtering, or database operations.

It would be beneficial to have a function that allows formatting a DateTime value while retaining its DateTime data type, reducing unnecessary conversions and simplifying date handling.