calday YTD, MTD in Query Designer
I have to show daily sell in a company + sell value from the beginning of the month, and from the beginning of the year.
how to get YTD and MTD values for specified day i Query Designer. I know I need to create variables that will work on calday, but how to do it?
Edited by: Andrzej Szaranek on Jun 2, 2011 2:09 PM
You cancheck out the below SDN thread for the MTD, YTD requirement as required by you.
Also you would find the below How-to guide for MTD, YTD calculation very helpful:
Hope this helps.