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.)
Question
Remote
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 RemoteLink to comment
Share on other sites
1 answer to this question
Recommended Posts