Page 1 of 1

Current system date

Posted: Mon Jun 27, 2005 2:32 pm
by Daisy_(Guest)
I have a field "Re" and the data inside this field is dates. What I want to do is subtract the current date from the "RE" filed __Thanks for the help.____Daisy____

=> RE: Current system date

Posted: Tue Jun 28, 2005 8:21 am
by kfleming
The DATE() function returns the current system date. You can use the DAYSBTWN() function to find the number of days between two date values.____Kathleen__R&R Support