Click here to Skip to main content
15,918,596 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to create a formula like this(below) but it arises an error. I have mentioned the error here within double quotation mark
"A number is required here". This error is occured in the else portion
I want to show the normal date in the else portion. Please help me


if {Table1.ToDate}=""
then
month(datetime({Table1.FDate}))
else
datetime({Table1.FDate})
Posted
Updated 7-Apr-13 19:17pm
v2
Comments
Aarti Meswania 8-Apr-13 1:25am    
what o/p you want???
if ToText({Table1.ToDate})="" then
// what to display?
else
// what to display?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900