ms access - Return a "mmm-yy" value from an acecss query -


i writing query need return set of data, 1 of needs date in format mmm-yy.

i using format(datevalue([cccontactdate]),"mmm-yy") shows in excel apr-17 value in cell still 02/04/2017 , need report month , year.

is there way amend query return apr-17?

use monthname(month(ccdate)) & "-" & year(ccdate)


Comments

Popular posts from this blog

javascript - Clear button on addentry page doesn't work -

python - Error: Unresolved reference 'selenium' What is the reason? -

asp.net ajax - Jquery scroll to element just goes to top of page -