18
Views
4
Comments
Solved
I need to change date format
Question

Issue: The event date is displaying as "01/01/1900" as the default for all achievements.

Approach used: I need to change the date format of a value in dd/mm/yyyy format but unable to change it as it is always returning default value.
Below is the code used for changing the expression : FormatDateTime(TextToDate(FilterdAchivements.Current.EventDate),"dd/MM/yyyy")


Given format (FilterdAchivements.Current.EventDate):Dec-24-2020
Expected format:24/12/2020



Rank: #2861
Solution

Hi Ananya,

Please try to implement the bellow JavaScript in our logic.

You can also refer to the following link and oml.

https://personal-auskcdz2.outsystemscloud.com/FormatDate_JS/TestDateFormat?_ts=637444491876816057

FormatDateJS.oml

mvp_badge
MVP
Rank: #2

Hi Ananya,

If  FilterdAchivements.Current.EventDate is displaying as 1900-01-01, this means that's the value of holds. Debug your program to see why.

Rank: #2861
Solution

Hi Ananya,

Please try to implement the bellow JavaScript in our logic.

You can also refer to the following link and oml.

https://personal-auskcdz2.outsystemscloud.com/FormatDate_JS/TestDateFormat?_ts=637444491876816057

FormatDateJS.oml