Hi,I'm trying to make a variable for "Last Year". Is this the right way to do it in Space Management -> Manage Variables: SELECT [Time.Year] FROM [ALL] WHERE [Time.Days Ago]=-1
Hi Herman,You can try the result from Query Admin for the SELECT statementIt will not give you the exact result.Regards,Kumar R.
Hi Herman,You may try thisRegards,Kumar R
Thanks! I will try it!
You can try this.... That way it always goes off the current year
SELECT [Time.Year] FROM [ALL] WHERE [Time.Year] = DatePart(Year,NOWDATE) for 2022
SELECT [Time.Year] FROM [ALL] WHERE [Time.Year] = DatePart(Year,NOWDATE)-1 for 2021
Thank you so much Stacy! This worked out perfect with current year, although do you know why I do not get the same positive result when I try last year or last monthSELECT [Time.Month] FROM [ALL] WHERE [Time.Month] = DatePart(Month,NOWDATE)-1 for last month
Last year should work... it does for me?
