|
-
Nov 10th, 2006, 10:36 AM
#1
Thread Starter
Lively Member
[RESOLVED] null dates in formulas
Please help me if you can!
I have a formula to display two dates and some text if the dates are not null. But it is not working. The formula is this:
If isNull({reportview_TimeToTransfer.ExStartDate})
and
isNull({reportview_TimeToTransfer.ExEndDate}) Then
' '
Else
CStr({reportview_TimeToTransfer.ExStartDate}) & ' - '
& CStr({reportview_TimeToTransfer.ExEndDate}) & ' (Extension)'
If it worked correctly, it should show:
01/01/2002 - 12/01/2002 (Extension)
or if the dates are null, it should be blank. But if the dates are null, it is showing:
- (Extension)
Any ideas anyone?!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|