• 0

Microsoft Access SQL


Question

I have a field A2.TermDate which is formated as Date/Time (MM/DD/YYYY)

I need subtract 1 day from the record in that field. How Do I do that?

Also, if possible, I need to reformat it as YYYYDDMM (no "/") (I can easly do this in another query once i have the -1 day, but if its possible to do it in the same select statement, it would be more effiencent.)

Thanks!!!

Edited by Remote
Link to comment
Share on other sites

1 answer to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.