Date Format for Testing SQL Widget

Date Format for Testing SQL Widget

  

Hi,

I want to test the SQL with the test inputs.

However i encounter the date format issue.What is the date format that OutSystems using?

Does anyone has idea on this?Help!!


Solution

Try this format: #yyyy-mm-dd#

Solution

Hi Johnson Lim.

The correct format you need to use is #YYY-MM-DD#.

So, for your example, you should use #2017-12-12#.

Cheers,

GM

Thanks Paulo and Goncalo