Brain Fart

[Tarheelfan]

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!

[Vaughan]

Why not just do something like

Test Date<= 6/30/2003

You can compare dates fields with date strings.