Query for Date Filter

Finance and Operations/AX Developer Forum
1

Hi all,

i need the Query statement and range for given below code

SELECT * FROM mytable WHERE ((FromDate>={ts ‘2016-01-01 00:00:00.000’} AND ToDate<={ts ‘2016-09-15 00:00:00.000’}))

2

Please stop creating more and more threads about the same thing. Please continue in your original thread: Query for date filteration. I gave you an answer there six days ago; ask there if you don’t understand something.

I’m slowly getting angry with you, because recently most work I do in this forum is managing your threads. I can imaging more productive use of my work. Please stop ignoring what moderators tell you. Just a warning…