how to format date in outsystems reactive?
Question
Application Type
Reactive

Hi,

When I select date from input widget it is showing me dd/MM/yyyy format that is correct. But when I debug it; it shows me yyyy-m-dd format which is incorrect for me. This format  I want to convert it into "dd/MM/yyyy" . 

in my Entity I have From column whose data type is DateTime.

1]


2] During debug


3] Error 



 

Please help me here


Thanks

mvp_badge
MVP
Solution

Hi,

The format as shown in the debugger is correct it is always in #yyy-mm-dd# format no matter how you format it in your user interface.

The FormatDateTime is a function that formats a variable expression or string literal of data type DateTime to a result value of data type Text. So the error you get is probably because the From variable is not of data type DateTime

Regards,

Daniel

Yes Daniel, you are correct. I changed it's Data Type and it is working now :)

Thanks

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.