UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Datediff, Access 2016    
 
   
mike60smart
post Jun 13 2019, 03:25 PM
Post#1


UtterAccess VIP
Posts: 13,181
Joined: 6-June 05
From: Dunbar,Scotland


Hi

I have a Control on a Continuous Subform named "TicketDate"

With another Control named "DaysOpen"

Can I have the "DaysOpen" Control continuously update to show the Number of Days from the TicketDate?

I get the actual number of days using "= DateDiff("d", [TicketDate], Date())+1"

If the Ticket was opened on the 1st June the value will be displayed as 13

But tomorrow when the user opens the database this value should show as 14

Any help appreciated in resolving this.


--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
June7
post Jun 13 2019, 03:27 PM
Post#2



Posts: 597
Joined: 25-January 16



The expression certainly should recalculate when form is opened or when data is changed or form requery/refresh.


--------------------
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
mike60smart
post Yesterday, 05:54 AM
Post#3


UtterAccess VIP
Posts: 13,181
Joined: 6-June 05
From: Dunbar,Scotland


Hi June7

For some reason it is now calculating as it should

Thanks for looking
cheers.gif

--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    15th June 2019 - 09:54 PM