https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/42718.aspxWed, 10 Jun 2009 19:05:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:42718Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/42718.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=42718<p>Add data validation to the field that the date picker is bound to. Your data validation should have two conditions -- the first would be <strong>Status</strong> = <strong>Completed</strong> and the second would be <strong>DatePickerField</strong> is blank.You&#39;ll want to leave the default &#39;and&#39; between the conditions. Then you can enter the error information in the Screen Tip field. Hope that helps!</p>https://www.infopathdev.com:443/forums/thread/42714.aspxWed, 10 Jun 2009 18:19:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:42714Lisa Choi0https://www.infopathdev.com:443/forums/thread/42714.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=42714<p>Hi,</p> <p>&nbsp;I am trying to create a logic formula in my web enabled InfoPath form.</p> <p>&nbsp;If status field = completed, then date picker field is greater than 00/00/0000</p> <p>Basically, I want to use the cannot be blank option for date picker if status field = completed</p> <p>if the status field = In Progress, the date picker is hidden until status field becomes Completed.</p> <p>&nbsp;is there another solution?</p> <p>Many thanks!</p> <p>Lisa</p>