|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Calendar Month | |
| rosenowsr 9/21/2012 8:34:01 AM | Is using calendar month in SQL a viable alternative to forward testing a UDM?
| |
| jeff 9/21/2012 11:41:52 AM | It is. However, a better alternative might be to name the UDM in such a way that the UDM name reflects the date last modified. For example, one of my "A" UDMs is named "0_A-0aAutoUPR1_05212012" (without the quotes.) Hint: The numbers at the end of the UDM name tell me the date last modified. From there, evaluations about the UDM going forward are easy to do . Just use the [DATE] field like this: AND [DATE] >= #05-21-2012# -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |