on 02-13-2009 8:28 AM
hi all,
how can i get the value of the previous quarter and previous month using using NOW() function in the formula.
regards,
Rk
Edited by: Rk on Feb 13, 2009 9:28 AM
Hi all,
Im using the formula "DSTR(DADD(NOW(),-1,'M'),'YYYYMM') " for getting the previous month, but im not able to get the previous quarter with a similar formula.. i.e "DSTR(DADD(NOW(),-1,'Q'),'YYYYQ')",
any help would be highly appreciated.
regards,
Rk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.