I am on BOBJ 4.0 and I have a requirement to calculate the beginning of the month for each date in a field. In other words, I have a "closed date field" which is displayed in the format 2013-10-18 18:13:00.0000000. Now for this value I want to add a calculation to say 2013-10-01. So for each value in the closed date field I want it to display the first day of that month. Is there a way to d this in Information Design Tool (Universe Designer) using DateAdd or any other functions? This is quite urgent. Any help would be much appreciated.
Thanks in advance!