May be u can do like this : datePer1 = mkdate(1, mthofyr(Periode), year(Periode));
Regards, Rony Wijaya, S.Kom | IT Developer PT. KOKOH INTI AREBAMA, Gedung Graha Atrium Lt.9 Suit 902, Jl. Senen Raya No. 135 Jakarta Pusat 10410, Indonesia Phone : 0811 991 0280 | E-mail : rony.wijaya.e...@gmail.com | YM : rony_...@yahoo.com ----- Original Message ----- From: arykamal07 To: development-axapta@yahoogroups.com Sent: Thursday, March 05, 2009 11:18 AM Subject: [development-axapta] Filter Date (just Month and Year) I want to filter query with month and year. I must convert the input of date to format month and year. I use : strper1 = "01/" + date2str(Periode,0,0,0,2,0,0) + "/" + date2str(Periode,0,0,0,0,0,4); dateper1 = str2date(strper1,123); But, its not work. Anyone to help me? Thanks [Non-text portions of this message have been removed]