Current system date

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Daisy_(Guest)
Posts: 4
Joined: Tue Oct 10, 2017 12:44 pm

Current system date

Post by Daisy_(Guest) » Mon Jun 27, 2005 2:32 pm

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____

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Current system date

Post by kfleming » Tue Jun 28, 2005 8:21 am

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

Post Reply