I have data about transaction date with format is "yyyy-mm-dd". But in drop down list, i only want to show "mm-yyyy".
I use this function in value
DATEVALUE(DATERANGE(DATE(SLICE(@K:K),"dd/MM/yyyy"),TODAY()),"MMMM yyyy") and add hidden data with same function of value.
But it not show anything. Please help me for solving it.