Formula

if FechaR4 <= DataDate and FechaR4 != 0 then 'Hito 4' end

I have a numeric field with that formula, that need take the info in Hito4 but don't work

Some body help, aprecciate

- Fred
- 2 yrs ago
- Reported - view
Hi Rafael -

With any if statements are you sure that you are asking correctly? If you change the code to:

if FechaR4 <= DataDate and FechaR4 != 0 then "True" else "False" end

Do you see the appropriate results in each record?
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Reported - view
Using that I see False
- Fred
- 2 yrs ago
- Reported - view
do any records show True?

if not then shorten the code to just:

if FechaR4 <= DataDate then "True" else "False" end

If you still do not get any trues then:

1) what kind of field is FechaR4?

2) what kind of field is DataDate?
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Reported - view
Yes for FechaR4 and FechaR3 False but FechaR2 and FechaR1 True is ok

FechaR4 is DateReal4

DataDate is CutffDate
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Reported - view
FechaR4..R1 is DatePlanR4 and te DataDate is the Cutoff date and de H4..1 is Milestone
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Reported - view
Now is working Thanks

if FechaR4 <= DataDate and FechaR4 != 0 then
   'Hito 4'
else
   if FechaR3 <= DataDate and FechaR3 != 0 then
       'Hito 3'
   else
       if FechaR2 <= DataDate and FechaR2 != 0 then
           'Hito 2'
       else
           if FechaR1 <= DataDate and FechaR1 != 0 then
               'Hito 1'
           end
       end
   end
end

Content aside