Показать сообщение отдельно
Старый 06.05.2008, 20:05   #1  
Blog bot is offline
Blog bot
Участник
 
25,475 / 846 (79) +++++++
Регистрация: 28.10.2006
palleagermark: Dynamic date ranges in queries
Источник: http://palleagermark.blogspot.com/20...n-queries.html
==============

When you send recurring jobs to the batch queue, there will be cases where you’d like some of your date criteria to be dynamic to match the system date.

You can use the “d” shortcut as criteria when you enter query selections and the system will convert “d” to the system date when the batch job is executed.

You can also use “d” in ranges:
..d = From date null (1/1/1900) until today
..d, !d = From date null (1/1/1900) until yesterday

I have tested these criteria on 4.0, I’m not sure you can do this with earlier versions. But please let me know if you can.

Источник: http://palleagermark.blogspot.com/20...n-queries.html
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.