differences between dates

[Jorgitopeter]

Hi everyone! I have this little issue and couldn't find any answer in other topics. I hope you can help me. Thanks in advance!

I want to compare 2 dates: the current date, and the one written by the user. I want to know if the date written by the user is more than 60 days older than the day when the user is writing.

I mean, the user writes a date of a specific day (e.g. 07/15/2010). I'd want a calculation field that tells me if there are more than 60 days between the date written by the user, and the day when the user is writing (today 08/02/2010).

Please let me know if my bad English isn't good enough to be clear. Thanks again!

[Lee Smith]

Hi Jorgitopeter,

What do you want to happen when the dates the meet your criteria?

[Jorgitopeter]

Hi Lee, thanks for answering.

What I'd need is that when the date written by the user is older than 60 days from the current date, the field returns 'NO'; if it isn't, the field should return 'YES'.

Can you figure that out? thanks a really lot!

[efen]

Create the calculation field (result text) as

If(UserEnteredDateField ≥ Get(CurrentDate)- 60; "No"; "Yes")

[Jorgitopeter]

Thanks... tomorrow I'll test this field and then I'll tell you if I have lucky! Thanks a lot!!!

[Jorgitopeter]

Great! Thanks a really lot for the help... I couldn't figure out how addition and substraction work with dates! Thanks again!