Newbies Tarheelfan Posted February 12, 2004 Newbies Share Posted February 12, 2004 Help! I knew this before, but old age must be setting in. How do I convert a date to a numeric value that can be used in a calculation? (ex. Case(Test Date<= 731573, "Fall Semester 2003",Test Date>= 731574 and Test Date <= 731707, "Spring Semester 2004", Test Date <= ""). I need to know how I converted a date to 731573, for example. I have forgotten. Thanks! Link to comment Share on other sites More sharing options...
Vaughan Posted February 12, 2004 Share Posted February 12, 2004 Why not just do something like Test Date<= 6/30/2003 You can compare dates fields with date strings. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7372 days old. Please don't post here. Open a new topic instead.
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