PDA

View Full Version : Managing dates



milingo83
04-10-2008, 10:42 AM
Hi,
I'd like know several things about dates and MQL constraints:

1. I tried to define a new physical column using the NEW() formula but i get a "column "now" does not exist" error. The weird thing is that it seems to recognize the function and return a "new" string (if you try to use a wrong function such as NEWD() you get a "not recognize" error). This happens in the metadata query editor, WAQR tool and in every formula definition within physical or business columns. What am i missing?

2. I need to add filters over dates to constraint the queries to a certain day, week or month. I know i can do this with a single day using the NEW() function, but i don't see the way to define a weekly or monthly MQL constraint. Is this possible? If not, is there a workaround or should i use a different reporting tool?

Thanks to anyone that can shed some light on this matters.