Hello - I am trying to show data only till the end-of-last Month. So that the trend report are always reported at the EOM. In Tableau V5 I Was ble to accomplish this by filter on the date field, seleting the 'Individual dates' type of filter, 'Use All' in the General tab, and use the following formula
[Your Date] < DATETRUNC('month',TODAY())
But I 've notived that this nolonger works in V6. I always get invalid Syntax.
This calculation should still work. Try creating it as a calculated field and place it on the filter shelf. Then, select the 'True' options. If this still does not work, are you able to post screen shots? And what version of 6 are you using?