[development-axapta] date & query bug

[Joannick Bacon]

Hi again everybody, we've encounter a bug lately in axapta



When we're making a queryRun and adding date value with the date2str() function, that date isn't recognize.

We've trace the problem to the source, the regional settings of Windows.



           The real problem is : we're using the date format 'YYYY-MM-DD' in the query, but since one user is in format 'DD-MM-YYYY', the query range isn't not associated correctly, thus some data is left behind.



Does any of you have a hot fix for this problem, or do we have to return in all our reports with this problem and correct it to date2str(_date,-1,-1,-1,-1,-1,-1,-1)?



Thanks in advance



---------------------------------------------------- 
Bacon Joannick 
Stagiaire Informatique / IT trainee  
B O A - F R A N C   |   M I R A G E 
T  418.227.1181 #2313
F  418.227.1188 
---------------------------------------------------- 
www.boa-franc.com 
---------------------------------------------------- 



Yahoo! Groups Sponsor	 
	 
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.