Regarding the input data type, I am aware that its a string that goes in.
In India, we use dd/MM/yyyy, and I know we can convert it by appending a .ToString(dd/MM/yyyy") to get the desired response, but the reason I wish to make this conversion is because after refining the data, it is pooled into an Oracle DB where the Data Column is of Type DateTime.
I wanted to know if it was possible to get the result in DateTime Format(As you can see above in the screenshot, there is a System.DateTime format), which is in [dd/MM/yyyy].
No, it’s a string that comes OUT. It can’t be anything else. In order to display the value that’s inside a DateTime you MUST output it as a string. You aren’t converting what’s inside the DateTime variable. You can’t, anyway. It’s a DateTime.
It’s just like if you have a variable myInt (Int32) with a value of 3, if you want to display that 3, type it into a web page, etc you MUST output it as a string with myInt.ToString. You aren’t changing what’s in the myInt variable, you’re just outputting it as a string.
“get the result in DateTime Format”
There is no such thing. This is a nonsensical statement.
Then as long as the column with the date in it is a DateTime column, that should work. You don’t need to do any sort of conversion of the DateTime value, no formatting, nothing - there is no format inside a DateTime. Oracle will understand the value. It would probably understand it properly even if it’s a string column in the DT.