Convert a date type into year&month format

I am sure some other people have blogged this somewhere, but I'd like to add this to my list of topics because I have encountered this type of requirement quite often.Basically, let's say we have a column called 'shipped date' that has data like 'YYYY-MM-DD'. If we want to change this data so it displays only year and month, like 'YYYY-MM' or 'YYYYMM', then how would we do it?First of 'YYYY-MM-DD' is date datatype but once we change it to 'YYYYMM',...

Read More

IBOT: Difference between the two Data Visibility setting

I know this is a very basic point about setting up IBOT, I still think it's worth noting on the blog for those who only knows the difference conceptually but not practically.As you can see, there are 2 optional for 'Data Visibility' setting when creating any IBOT:So what exactly does IBOT do when the setting is 'personalized' and when is not 'personalized'?Personalized setting: The IBOT will execute the report and delivery its content for each individual...

Read More