UserResponse Function :if Date datatype is String

[siva_ram20]

Hi

I have the open date in this "11/12/2018 12:00:00 Am" mentioned format but when user give parameters on the open date the user response must be in this format " 11-DEC-2018"

Here the Date having the Datatype is "String "

i

[jyothirmayee_s]

Hi,

Use ToDate() and formatDate() functions.

=Formatdate(Todate(Userresponse([stringdate];"dd/mm/yyyy")),"dd-MMM-yyyy")

https://blogs.sap.com/2016/07/28/formatdate-and-todate-a-simple-guide/

Thanks,

Jothi