jerradmills Posted December 22, 2004 Posted December 22, 2004 I am trying to subtract 1 year from a field that already has a date within it into a new field i.e 1/1/2001 shows in 1 filed i would need the next field to show 1/1/2000 How can i do this? Thanks, Jerrad
-Queue- Posted December 22, 2004 Posted December 22, 2004 Date( Month(datefield), Day(datefield), Year(datefield) - 1 )
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now