Thank you in advance.
Thanks for sending in the case. Do you think you could give us an example of the fields you are working with? For example what is the format of your original date field, and are you using a predefined function or are you trying to convert this date using your own SQL?
Could you attach a couple of screenshots demonstrating what you are trying to accomplish so that we can try to work this out on our end and provide a potential workaround?
I look forward to hearing back, and helping you get to the bottom of this one.