Could anyone please let me know how I could use the VBA function Now() to get the current time and assign it to the (year-month) hierarchy?
I need this for a report which retrieves amount collected in the past 24 months from the current date.
I have read that I could use the VBA functions but I am not sure how to assign it to the time dimension hierarchy and then use the LASTPERIODS function to get the past 24 months of data.
Any help would be greatly appreciated.
View Complete Post