[Solved] Filter subForm by date

[te4o93]

hello everybody, i need help to filter a subForm by date parameter
it doesn't get any error but for every date i try to set it clears the subForm
this is what i'm trying to do
(my date format(italian) is DD/MM/YY)

Code: Select all

   dim oFilter as object

	oForm = ThisComponent.DrawPage.Forms.getByIndex(0)
	oSubForm = oForm.GetByName("SubForm")  
	
	oSubForm.Filter = "'Date' >= '20/03/16'"
	oSubForm.ApplyFilter = True
	
	oSubForm.Reload 
End Sub

Thanks

[Villeroy]

'20/03/16' is not a date.
'2016-03-20' is a date.

[te4o93]

thanks i fixed it with this --> {d 'yyy-mm-dd'}