re: Filtering for an NA date in a PWA View

Wim Van Den Bergh — Thu, 18 Jun 2009 14:38:53 GMT

Hello,

To detect NA-date values, I use the value 4294967295:

in case [your date] is NA,

[your date]=4294967295 returns true!!!

This way you don't have to choose characters that are always in your date.

This number equals 2^32-1. Maybe -1 will do the job too, since it equals 2^32-1 in a 32-bit system but I didn't try it until now.

Regards

Wim

re: Filtering for an NA date in a PWA View

brianken — Thu, 18 Jun 2009 19:09:21 GMT

Wim,

What you are suggesting is certainly true in Project Professional custom field formula but NOT true in PWA view filters. The PWA view filter dialog does not allow you to put such a value into the 'value' property of a filter criteria line.