datevalue function takes a date as a text (or string) as input and returns outpu

datevalue function takes a date as a text (or string) as input and returns output as Date object (if the input text is a valid date text)
input format dd/mm/yyyy - this format works perfect.

but if I give the input as dd-mm-yyyy (for ex: datevalue("9-6-2009") - this returns output as "6/9/2009" . Why the month and date are interchanged in the output ?

OriginalPostID-174659

OriginalPostID-174659