I am struggling to complete a formulation for calculating the expiration of data entered which depending on which database table they are in depends on their expectoration time, either 24hrs, 7days, 14days or 21 days.
If there isn't any withing that particular table then it will default to 14.
This is my so far attempt, but have gaps i know and it is so frustrating that I cannot get my head around it....If anyone can shed some light it would be gratefully appreciated.

@example = INT(Table.example/2) MOD 2 <> 0

Open in new window


If {@example} then 1
Else
(

If IsNull{table.NAME} then
14
Else if {table.NAME}= help then
7
Else if {table.NAME} = more help then
21
Else
14
) 

Open in new window

0
LVL 102

Expert Comment

by:Mike McCracken
You probably should ask this as a question as not all Crystal experts follow the posts.

There is a BLUE button for ASK
https://www.experts-exchange.com/askQuestion.jsp

Need more information as to when each length applies

mlmcc
1

Author Comment

by:Kev wood
Sorry didn't realise, thank you. I have now done what you have said.
1

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month