todate function is returning date format in user

Hi,
I am using todate() function to convert a text to date value. The function does not take any parameters for dateformat.
the function always returns the date format based on user locale preference only. Is there any alternate approach that I can try, thanks in advance for the suggestions!

OriginalPostID-260360