For example, If I wanted to have a have an equation that said something like "If the current date/time is between 00:00 on June 1st and 23:59 on June 15th then 1 else 0" how would that be written? Also, can it be an equation that would only look at that date/time range or do I have to specify the year as well? Its for something that happens every year so it would be handy to not have to update the equation annually to the new year, just write it and forget it.
I have an equation I use daily that is:
if ('*' in '6:30' .. '6:50') then 1000 else 1200
This works just fine and returns the result I need everyday between 6:30am and 6:50am. I am unable to get the same result with using months and days instead of hours and minutes though.
What date format does PI Vision like in the equations?
I have tried YYYY-MM-DD, DD-MM-YYYY, and DD/MM/YYYY. All seem to not work.
