Show Date as yyyy/mm 1

[hefly]

How do you show date as Year/Month?

2011/11
2011/2

I can only get "yyyy"

SELECT DatePart("yyyy",[Dated]) AS YrMo
FROM tbl_Leases;

Thanks

Hefly

 

[dhookom]

SELECT Format([Dated],"yyyy/m") AS YrMoFROM tbl_Leases;

Duane
Hook'D on Access
MS Access MVP

 

[hefly]

I was trying all kinds of iterations in the code,, but nothing!

Thank you DHookom!

Hefly