Hi all,
I am trying to take a date value from a DB(which I am writing in the Expression value below) and once I am inputting it in rule input it is changing my date value(Refer Value field):
Can anyone guide me what I am doing wrong, I need 03/10/22 as an output.
Thank you.
Discussion posts and replies are publicly visible
Use todate("03-10-2022")
Thanks Shalini, but how can we convert "2022-10-03" that is coming from database to "03-10-2022" ?
Hi,
If it's consistent just use
todate( joinarray( reverse( split(ri!date,"-") ), "/" ) )
I guess that the DB column it's string so note that ri!date should be of type text
Is there a specific reason to store a date as a string in the database? Using a date field would avoid all the hassle.
Splitting and then Reversing worked well in this case, thanks Gabriele Camilli