Select Statmant in DateTime Filed

Finance and Operations/AX Developer Forum
1

hi all

I Have a grid With Field (InventQualityOrderTable).ValidatedDateTime

i Want to Write Select Command That Select Between 2 Date Time ( For Example 01/01/2014 07:00 Pm to 01/05/2014 10:00 Pm or just select by Time between 07:00 to 09:00

how Can I do this cod2311.9999.gife

2

You have to get values of utcdatetime type. If you don’t have them, use DateTimeUtil::newDateTime(), for instance. Then write the select statement as usual, using the utcdatetime values with > and < operators.