Conversion of text to date in db

I am storing the date in an entity in YYYY-MM-DD format.

I am using data picker and then assigning it to a date variable of text type in YYYY-MM-DD format.

Now I want to compare this inputted text date to my db date and when I am using inbuilt function text to date, it is not working.

Any solution?

Any error message when you are using the TextToDate? 

You may also try to debug what is the value of your inputted text before applying the TextToDate().

Shubham Agarwal wrote:

I am storing the date in an entity in YYYY-MM-DD format.

I am using data picker and then assigning it to a date variable of text type in YYYY-MM-DD format.

Now I want to compare this inputted text date to my db date and when I am using inbuilt function text to date, it is not working.

Any solution?

Hi Shubham,

Please check once your service center DateFormate from Administration->Environment Configuration.

when you compare date its automatic take service center date formate.

hope attached oml will helped you.


https://rahul-sahu.outsystemscloud.com/BPT_Test/DateTimeCompare.aspx