Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Sangeetha
3914
valid dateFormat for datevalue function
posted

Hi,

I would like to use the datevalue function in the FormulaBuilder. But unfortunately no matter what dateformat I use, it displays #VALUE! in the cell.

Which date format does it use? I am using Infragistics 11.2

Thanks

Sangeetha

Parents
No Data
Reply
  • 469350
    Verified Answer
    Offline posted

    Hi Sangeetha,

    I tried this out and it works fine for me. Just as a test, I used "3/4/12" just as an arbitrary date string and it shows up correctly in the grid.

    It might be a problem with localization. I think the CalcManager expects the dates to be in the InvariantCulture. So it's always Month/Day/Year.

Children