date differential

This topic is locked

date differential	5/30/2007 4:52:59 PM
ASPRunnerPro General questions
S SteveL author HI there I have a returned authroization database where I want a field that tells you how many days a unit has been received. For example I have a field called "DateUnitReceived" this is a date field that is entered when the unit arrives. I have another field called "DaysInQueue" which would be the current date - "DateUnitReceived. I want this field updated automatically and dynamically from todays date. Any help would greatly be appreciated it.


	Sergey Kornilov admin 5/31/2007
	It looks like you need to use a SQL query with calculated field which should display number of days. Depending on database that you use you need to use either DateDiff function or something else.