YANKRAY
Technical User
- Nov 7, 2003
- 283
Using CR10
I am having trouble creating a formula that will give me a string result if I have a null value in a date field.
I am writing my formula as follows:
if isnull({PEM_KC135_OPEN_ITEM_MVW.CURRENT_PROM_DATE})
then "No EDD Date"
else {PEM_KC135_OPEN_ITEM_MVW.CURRENT_PROM_DATE}
I get the error that a string is required for my "else" date field.
How do I get my formula to work so where I have a null value for a date I get the words "No EDD Date"?
Thanks,
Ray
I am having trouble creating a formula that will give me a string result if I have a null value in a date field.
I am writing my formula as follows:
if isnull({PEM_KC135_OPEN_ITEM_MVW.CURRENT_PROM_DATE})
then "No EDD Date"
else {PEM_KC135_OPEN_ITEM_MVW.CURRENT_PROM_DATE}
I get the error that a string is required for my "else" date field.
How do I get my formula to work so where I have a null value for a date I get the words "No EDD Date"?
Thanks,
Ray