Data Extraction

[#1]

Hi

I have my data in format yyyy-mm and I would like to have list box for year and month.

I have used Year(dataname) as year ... But it doesn't work. What is the way yo do it?

[Anonymous]

Year((Date#(<your field>,'YYYY-MM')))

[antoniotiman]

HI,

try

Year(Date#(field,'YYYY-MM'))

and

Month(Date#(field,'YYYY-MM'))

Regards,

Antonio

[#4]

Thanks. It solved