How to use DateTime constants in DataTable.Compute

Question

There are some informations about it in Framework Help but they are incomplete I think. Some examples: 1. compute property: datetime is without apostrphes as MM/dd/yy 2. expression property: datetime is in hashes as MM/dd/yy 3. null datetime as ## doesn't work 4. when I use DateTime.ToString() results depends on international settings or kind of operation system. 5. I couldn't find any information about datetime format in msdn May be someone knows how to use it? Thx in advance

Andrzej Wegierski · Answer

Now American format MM/dd/yyyy works I think (with Polish settings in Win)

Andrzej Wegierski · Answer

Doesn't work in some cases. Should be yyyy-MM-dd format. Shit. Does anyone use dates under .NET ????

Andrzej Wegierski · Answer

May be myDate.ToString(u).Replace(Z) would be work.

Andrzej Wegierski · Answer

Now I have an example where u doesn't work: mydate: 2004-03-01T00:00:00.0000000+01:00 for Compute: dt = # + mydate.ToString(u) + # e.g: dt = #2004-03-01 00:00:00Z# doesn't work dt = ' + mydate.ToString() + '  e.g.: dt = '2004-03-01 00:00:00'  works ok. Buuuuu!

Andrzej Wegierski · Answer

Partially solved. datetime.ToString(u) works independently of system date format.