Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Null in formula 1

Status
Not open for further replies.
ProgEval

ProgEval

MIS
Sep 21, 2006
59
0
0
US
I have a formula that converts a date string to a date field.

If isnull(datestring)
Then
(I want the formula to show a null value)
Else
cdate(datestring)

Thanks in advance.
 
Sort by date Sort by votes
If isnull(datestring) Then
date(0,0,0) Else
cdate(datestring)

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
102
john432
john432
Corinne30
  • Question
Division of currency formula with/without rounding
Replies
7
Views
338
dgillz
dgillz
Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
101
lbass
lbass
john432
  • Locked
  • Question
Crystal Report formula (finding with key words) 1
Replies
2
Views
98
john432
john432
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
104
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top