HI,
My data has time period in multiple formats like- “this month” , “this year” or “March 2016” or “Q1 2016”. What is the best way to grab this info in a single slot? I need to be able to run an sql query with the value stored in this slot.
Thanks for the suggestion. I get it that the above method will help capture March 2016, April 2018 etc. But can it also get “this month” , “last month”, “next quarter” etc? or will I need a separate slot for that?