Text to Date Conversion - Support For More Formats

Builtin & User functions
On our radar

Usually there is a requirement in applications to support various date formats different from the one used by server for storage. This typically involves conversion from server format to user preferred format and vice-versa while storing user input. The TextToDate built in function does not support any format other than these : YYYY.MM.DD, YYYY-MM-DD and YYYY/MM/DD.  It does not even support the date formats which are available under Environment Configuration in Service Center. This limitation becomes a hurdle and forces developers to find alternatives or use extensions.

It would be really great if future release of Outsystems can support more formats in TextToDate probably by adding more arguments to function to properly understand the provided formatted date text and convert it to date.

Created on 12 Sep 2018
Comments (4)

Changed the category to Builtin & User functions

Changed the status to
On our radar

Hi Junaid,

Thank you for your contribution in the community. We will evaluate this need and mark it as in our radar right now.


I agree, the database default is not user friendly, the calendar pop up widget can be formatted differently so, we should have a function to make sure it's a valid date if a custom format is submitted (using for example TextToDateValidate)

I agree, having this out-of-the-box would be a great addition.