Using Denodo 7.0 version.
I have date field in format 'MM/dd/yyyy' in my source which is in text datatype. I need to project the same in same format('MM/dd/yyyy') but in date datatype. When i use *CAST*, *to_date* ,*to_localdate* ....., format is changing. And we know, *formatdate* function will give output as text format, so there's no point of using it as mine is already in text format.
is there any function in denodo to get the value in same format with date datatype . Please help.
Thanks in advance.