Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dates Comparison

Status
Not open for further replies.
sabavno

sabavno

Programmer
Jul 25, 2002
381
CA
Hi,

I am having difficulties comparins the dates.

Here is what I do and it does not work:

If doc.PLAN_INSTL_DATE(0) < 11/01/2001 Then
'do something
Else


Even if doc.PLAN_INSTL_DATE is before 11/01/2001, script jumps to the ELSE condition.

Please help.


 
Sort by date Sort by votes
Is your field PLAN_INSTL_DATE a NotesDateTime field?

Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!
 
Upvote 0 Downvote
The best way to compare dates in LScript is to use NotesDateTime objects.

try the following code :

Code: 
dim docdate as notesdatetime
dim checkdate as notesdatetime

set checkdate = new notesdatetime(&quot;11/01/2001&quot;)
set docdate = new notesdatetime(doc.PLAN_INSTL_DATE(0))
If docdate.dateonly < checkdate.dateonly Then
            'do something
 Else

This should help you.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

HighLife
  • Locked
  • Question
Create list of dates for Date/Time field
Replies
3
Views
152
pmonett
pmonett
sabavno
  • Locked
  • Question
How to compare the dates
Replies
2
Views
375
rajeevturlapati
rajeevturlapati

Part and Inventory Search

Sponsor

Back
Top