Hello,
I am trying to create a small function that looks that a date field, finds the current calendar quarter, and then returns the previous quarter. I came up with the code below, however, because I subtract 1, when we are in quarter 1, the function/string returns 0. Any ideas how I can get this to show Q4 instead of Q0?
Thank you for your help!
TallMan
I am trying to create a small function that looks that a date field, finds the current calendar quarter, and then returns the previous quarter. I came up with the code below, however, because I subtract 1, when we are in quarter 1, the function/string returns 0. Any ideas how I can get this to show Q4 instead of Q0?
PHP:
strTrailer = (Format(RS.Fields("upload_date"), "Q") - 1) & "Q" & " " & "Payment"
Thank you for your help!
TallMan