Restrict data in IDT to current month only?
How can i restrict my data to Current month only. For me Period field is coming as string like '06/2015'.
Pleas help me on this.
Narashimman K S replied
Just realized. The operator should be >= and not <=
Also, make sure that the date conversion is working as expected by running the select statement directly against the db table. I doubt because period add returns full date and you just want month and year. you can give a try with the below filter: