I have a chart of events with dates I want to show ONLY if they are occuring tomorrow or later. I want to compare dates from my csv file (in YYYY-MM-DD format) to today’s date (via the ‘Special: Util – Current Date’). However, it doesn’t seem PF is able to compare the two dates. So, I also trying to replicate the format by using the following setup:
Year(Special: Util – Current Date) + ‘-‘
Month(Special: Util – Current Date) + ‘-‘
Day(Special: Util – Current Date)
But if the date is June 6th 2011 it will give ‘2011-6-1’ which is a problem. I am sure PerfectForms is powerful enough to be able to do something simple as date compare, but I can’t figure it out. Any help?