hi all..
this formula working well with /for full date format.
i want to modified how to make formula work with format date as month & year
cause my date as complete/full format (mm-dd-yyyy).![]()
=query(Data!$A$1:$H$136,"select C, B where B = date '"&text(G6,"yyyy-mm-dd")&"'",1)
my question how to display data with criteria date e.g. = 12-2001 (mm-yyyy)
for someone helping me, thank you so much..
john m
Bookmarks