[RESOLVED] How To Set Records Order According To This Kind of Field?

[xboner]

You can use the Format$() function

Debug.Print Format$(DTPicker1.Value, "YYYY/MM/DD")

Thanks, I'll try that

edit: But how to format the result right in DTPickers own textbox? with that, I might need to create a new textbox to store the value