Specifying current date value in report query form datetime field in Dynamics 2009 Ax

Finance and Operations/AX User Forum
1

Hi - hopefully a simple answer to this question - When running reports (or any query), trying to specify the value for the current date in a datetime field, how do you do it? In previous version, you could enter a “D” for the current date. “D” no longer works with datetime fields.

So just to be clearer - here is an example - In version 3 we have a report that runs as a batch every day, that provides a list of customers added to the system that day. So our query value for create date is “D”. How can I accomplish the same task in 2009 with the datetime field?

2

I would also like to know this, any update?

Thanks in advance.

3

(dayRange(-10,15)) will report for 10 prior days to 15 days in future.

(monthRange(0,0)) reports current month.

Is there a weekRange? haven’t tried this.