Skip to Content
0
Former Member
Dec 20, 2013 at 02:39 PM

Finding the first day of the month in a date field

1479 Views

Hello there,

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!


Cheers,

Divya Rajnarain

drajnarain@us.ibm.com