Comparing 2 Dates

[melligeorgiou]

I'm trying to find out if a date field has expired (by comparing it to the current date).

 

I'm currently doing this but it is working erratically (changing some fields that shouldn't be changed).

 

Customers::domain_name_renewal ≥ Get ( CurrentDate )

 

This is part of the script I'm running, but it's just this that is giving me problems. Any help would be greatly appreciated.

 

Thanks!

 

-Mel

[Ender]

That doesn't look like a script, it looks like a calculation. If it is used in a calculation, the Storage option must be set to "Do not store" in order to update. If it is used in a script, please list the whole script.

[melligeorgiou]

The If statement of the script is:

 

 

If [Customers::domain_name_renewal ≥ Get ( CurrentDate )]

 

Set Field [ Customers::has_account; "No" ]

 

End If

[LingoJango]

Shouldn't it be

instead of

>=

 

?

[Ender]

There's nothing there to set the field to "Yes" in the opposite case. Maybe that's causing problems.

[melligeorgiou]

Thanks a lot!

 

I knew it would be something as silly as that! LOL

 

(I had the greater than the wrong way round!)

 

Thanks a lt for all your help.

 

-Mel