Gains loss report help with access

[c9stealth]

I'm new to this Forum and to Microsoft Access, so that being said I'm sure this is an easy fix.

I am making a database for my unit and I am stuck on my gains loss reports. I've tried using the code below but, i only get results that are within 30 days but the year doesn't matter. I need the results to take in to cout the year also. for example:

right now I put in the code looking for dates of loss with in the next 30 days, my results would enclude:
29 Jan 1985
03 Feb 2007
12 Feb 2002

where all i want is to show the dates in the next 30 days: 03 Feb 2007

eventually I want to have reports that will do 30, 60, 90, 120 days till loss. but I should be able to figure it out if you help me with the 30 days.

heres the code i am working with. thanks in advance for your help.

 ((([DEROS]+((Int((Now()-[DEROS])/365.25)+1)*365.25)) Between Now() And Now()+30)) 

[willakawill]

Hi, take a look at DateDiff()

[ADezii]

I'm new to this Forum and to Microsoft Access, so that being said I'm sure this is an easy fix.

I am making a database for my unit and I am stuck on my gains loss reports. I've tried using the code below but, i only get results that are within 30 days but the year doesn't matter. I need the results to take in to cout the year also. for example:

right now I put in the code looking for dates of loss with in the next 30 days, my results would enclude:
29 Jan 1985
03 Feb 2007
12 Feb 2002

where all i want is to show the dates in the next 30 days: 03 Feb 2007

eventually I want to have reports that will do 30, 60, 90, 120 days till loss. but I should be able to figure it out if you help me with the 30 days.

heres the code i am working with. thanks in advance for your help.

 ((([DEROS]+((Int((Now()-[DEROS])/365.25)+1)*365.25)) Between Now() And Now()+30)) 

The Year doesn't matter because your Date Field is probably defined as Text rather than Date/Time. Make the Data Type conversion, and you should be OK.

[c9stealth]

I looked at DATEDIFF and am still having some trouble. Actually think I confused myself more. thanks for the help though. :)

[c9stealth]

The Year doesn't matter because your Date Field is probably defined as Text rather than Date/Time. Make the Data Type conversion, and you should be OK.

The date Field is defined as Date/Time, and it is still giving me the same results.

[NeoPa]

Two suggestions :

1. Use Date() rather than Now() for predictable results.
2. Take the code you use to determine the date (It refers to various items not explained here so don't expect us to understand what you're trying to do) and put it in a SELECT statement.
   See what format it comes out in. Is it a Date/Time value or a string or maybe even a numeric.
   When this is sorted out you'll be in a better position to use it properly.

[c9stealth]

Two suggestions :

1. Use Date() rather than Now() for predictable results.
2. Take the code you use to determine the date (It refers to various items not explained here so don't expect us to understand what you're trying to do) and put it in a SELECT statement.
   See what format it comes out in. Is it a Date/Time value or a string or maybe even a numeric.
   When this is sorted out you'll be in a better position to use it properly.

I guess this just goes to show I'm in over my head with this. I was using the above code to find birthdays comming up in the next 30days, but now i need to show dates of events in the future. so like if i wanted to see upcomming appointments with in the next 30 days it would show that.

Thank you everyone for your help, I think I still have a lot to learn so that I can help you help me, right now I just don't know what I'm doing.

Thanks,
gordy

[c9stealth]

Thank you to everyone who has been tring to help me, I've actually figured it out. just had to change Now() to Date() and changed *365.25 to /365.25 and that fixed it. heres the finle code for anyone who may want to use it down the road.

((([DEROS]+((Int((Date()-[DEROS])/365.25)+1)/365.25)) Between Date() And Date()+30)) 

[NeoPa]

Thanks for posting that Gordy.
It's always good to have a resolution post and I'm pleased you got it sorted out :)
I guess [DEROS] is your table's date field.

[c9stealth]

Thanks for posting that Gordy.
It's always good to have a resolution post and I'm pleased you got it sorted out :)
I guess [DEROS] is your table's date field.

Yes, sorry about that not telling everyone that.. DEROS is a millitary term. for date of loss. so I can keep track of when my soldiers are getting close to time to leave. thanks for the help!

[NeoPa]

Not a problem. Glad to help :)