asked on Help with formula
What is wrong with this?
if ({@DBSCheck}) = 'No' then 'NA' else ({MembersDetails.DBS Expiry Date})
it says a string is required after else
if ({@DBSCheck}) = 'No' then 'NA' else ({MembersDetails.DBS Expiry Date})
it says a string is required after else
Crystal Reports
Last Comment
Gordon Hughes
ASKER
Hi
I have modified the formula to
if ({@DBSCheck}) = 'No' then 'NA' else cStr({MembersDetails.DBS Expiry Date})
It partially works
what do I need to add to only see dd/mm/yyy not any hours
Gordon
I have modified the formula to
if ({@DBSCheck}) = 'No' then 'NA' else cStr({MembersDetails.DBS Expiry Date})
It partially works
what do I need to add to only see dd/mm/yyy not any hours
Gordon
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks all working great
Gordon
Gordon
Your else condition seems to be returning a date data type as the field suggests.
You need to typecast the date to a string using cStr({MembersDetails.DBS Expiry Date}) or cStr({MembersDetails.DBS Expiry Date}, <required date format for e.g MM/dd/yyyy>)
Hope that helps.