Days Aged Formula

[bwlytkr]

Need help with a Days Aged Formula. I would like to enter a formula in my access query to convert 01/01/2020 to days aged to current date. Anyone know a formula that I can enter to calculate that? The date Column is labeled NextToGoStartDate. Thanks John

 

[johnnyL]

If you wanted to check how many days have elapsed since the date shown in A1, for example, you could enter the following formula in a different cell:

= DATEDIF(A1,TODAY(),"d")

 

[Micron]

Since this was an Access question, the syntax is DateDiff ( interval, date1, date2, [firstdayofweek], [firstweekofyear])
so your calculated query field would be something like

NextToGoStartDate: DateDiff ("d", #01/01/2020#, Date())

 

[johnnyL]

oops! Sorry.

 

[bwlytkr]

Since this was an Access question, the syntax is DateDiff ( interval, date1, date2, [firstdayofweek], [firstweekofyear])
so your calculated query field would be something like

NextToGoStartDate: DateDiff ("d", #01/01/2020#, Date())

Thanks. There are various dates in the nexttogostartdate column so would I put something else in where you have the 01/01/2020 date in the formula? Some dates go back as far as 4 or 5 years

 

[Micron]

I thought that name was for the query calculated field name. If not then I guess you'd substitute that date with that field name and use something else for the name of the calculated field. I'm only going on the info you provide, and you specified that date in your first post, which is why I went with it. If that still isn't correct then I suggest you past a small table of sample data that includes field names.

 

[bwlytkr]

I thought that name was for the query calculated field name. If not then I guess you'd substitute that date with that field name and use something else for the name of the calculated field. I'm only going on the info you provide, and you specified that date in your first post, which is why I went with it. If that still isn't correct then I suggest you past a small table of sample data that includes field names.

Thanks for the info. I'l give that a try and let you know and send you a sample of the query if it doesn't work. Thanks again.

 

[bwlytkr]

Thanks for the info. I'l give that a try and let you know and send you a sample of the query if it doesn't work. Thanks again.

I couldn't seem to get the Access formula to work for me. Below is a sample from excel of what I am trying to achieve when I run the query. I would like Days Aged formula to run in my query so I don't have to copy it in excel each time I run my reports. Hopefully there is a way to do this. I also added a sample of the nexttogostartdate column from the Access query as well. Any help would be greatly appreciated. Thanks Again.

NextToGoStartDate	Days Aged
5/24/2021	11
8/12/2020	296
9/22/2020	255
5/24/2021	11
5/24/2021	11
5/24/2021	11
5/25/2021	10
5/25/2021	10
3/1/2019	826
5/25/2021	10

Query Column

NextToGoStartDate
PXFR02 NTG

 

[bwlytkr]

I couldn't seem to get the Access formula to work for me. Below is a sample from excel of what I am trying to achieve when I run the query. I would like Days Aged formula to run in my query so I don't have to copy it in excel each time I run my reports. Hopefully there is a way to do this. I also added a sample of the nexttogostartdate column from the Access query as well. Any help would be greatly appreciated. Thanks Again.

NextToGoStartDate	Days Aged
5/24/2021	11
8/12/2020	296
9/22/2020	255
5/24/2021	11
5/24/2021	11
5/24/2021	11
5/25/2021	10
5/25/2021	10
3/1/2019	826
5/25/2021	10

Query Column

NextToGoStartDate
PXFR02 NTG

No need to reply. I got it to work. Must have had something spelled wrong previously. Thanks for your help. It will be a great time saver for me.