A ahson88 Registered User. Local time Today, 20:13 Joined Feb 16, 2003 Messages 20 Feb 16, 2003 #1 i need an expression 2 work out the difference in dates between a date entered in a field and the current date. the date entered in the field is set to the format dd/mm/yy. can anyone help??? much appreciated
i need an expression 2 work out the difference in dates between a date entered in a field and the current date. the date entered in the field is set to the format dd/mm/yy. can anyone help??? much appreciated
Mile-O Back once again... Local time Today, 20:13 Joined Dec 10, 2002 Messages 11,316 Feb 16, 2003 #2 Look up the DateDiff() function in the help.
A ahson88 Registered User. Local time Today, 20:13 Joined Feb 16, 2003 Messages 20 Feb 16, 2003 #3 STILL STUCK YES BUT IM STUCK USING THAT BECAUSE IT SAYS EXPRESSION MISS MATCH
Mile-O Back once again... Local time Today, 20:13 Joined Dec 10, 2002 Messages 11,316 Feb 16, 2003 #4 What part are you stuck with? =DateDiff("d", YourFieldHere, Date()) So, if your field was called DateStart it would look like this: =DateDiff("d", DateStart, Date())
What part are you stuck with? =DateDiff("d", YourFieldHere, Date()) So, if your field was called DateStart it would look like this: =DateDiff("d", DateStart, Date())
A ahson88 Registered User. Local time Today, 20:13 Joined Feb 16, 2003 Messages 20 Feb 16, 2003 #5 still doesnt work ive tried that..but it still doesnt work. can i send u my database and u try it 4 me pls???
still doesnt work ive tried that..but it still doesnt work. can i send u my database and u try it 4 me pls???
Mile-O Back once again... Local time Today, 20:13 Joined Dec 10, 2002 Messages 11,316 Feb 16, 2003 #6 Post it here.
A ahson88 Registered User. Local time Today, 20:13 Joined Feb 16, 2003 Messages 20 Feb 16, 2003 #7 how do i do that?? i havent got it on the net. its on my harddrive. can i email it 2 u??
Mile-O Back once again... Local time Today, 20:13 Joined Dec 10, 2002 Messages 11,316 Feb 16, 2003 #8 What version is it?
A ahson88 Registered User. Local time Today, 20:13 Joined Feb 16, 2003 Messages 20 Feb 16, 2003 #9 2000
Mile-O Back once again... Local time Today, 20:13 Joined Dec 10, 2002 Messages 11,316 Feb 16, 2003 #10 Where exactly are you trying to do this? I'm looking at your database now and can't see where you are wanting to put the function in.
Where exactly are you trying to do this? I'm looking at your database now and can't see where you are wanting to put the function in.
A ahson88 Registered User. Local time Today, 20:13 Joined Feb 16, 2003 Messages 20 Feb 16, 2003 #11 in the overdue1 query. i want an expression that calculated the number of days between the current date and the date due back
in the overdue1 query. i want an expression that calculated the number of days between the current date and the date due back
Mile-O Back once again... Local time Today, 20:13 Joined Dec 10, 2002 Messages 11,316 Feb 16, 2003 #12 You've got mail.
A ahson88 Registered User. Local time Today, 20:13 Joined Feb 16, 2003 Messages 20 Feb 16, 2003 #13 Thanx m8. Much appreciated