Help with an Expression

G

Greg

We have a GroupBox on a Win Forms app that needs to display two date fields
like this:

01/01/2003 to 01/15/2003

We bind to the above date type datacolumns for editing purposes, but we also
need to display them as a range in the groupboxes text property. I thought
an expression in a custom datacolumn would handle this.

What I need to do first though is check the values of the date type
datacolumns. If they equal, lets say "01/01/1999" I do not want to display
them in the groupboxes text property. The property would be empty.

How can I do this with an expression? For example, say my date type
datacolumns are named Date1 and Date2. I want to show "Date1 to Date2" only
if both are present and not equal to "01/01/1999".
 
G

Greg

for those following along:

"IIF(names_beghold>#1/1/1800# AND names_endhold>#1/1/1800#, names_beghold,
'')"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top