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
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.
Thanks for your immediate reply Mike.
Is there anyway I can set the format to be the same as Regional settings format?
Mike,
Thanks a lot for your reply. Will try your suggestion.
I don't think there's any way to do this with the CalcManager formula. The CalcManager deals with everything in the invariant culture.
You could use the DateTime.Parse method in code to convert your string into a DateTime in the current culture, of course. So maybe you could create an unbound column in the grid and use the InitializeRow event to convert the string into a culture-specific date and then use that hidden unbound column in your formula.