I noticed on Google analytics that someone was looking to calculate in Business Objects, what day, the first day of the year was.
Here's how :
=DayName(ToDate(Year(CurrentDate()) & "/1/1" , "yyyy/mm/dd") )
If you want the number of the day
=DayNumberOfWeek(ToDate(Year(CurrentDate()) & "/1/1" , "yyyy/mm/dd") )
Yet someone else was looking for an equivalent of Instring in Business Objects. Look no further.. it’s Pos()
pos(“abcdefg”, “g”) = 7, so, g is located in the 7th position.
Easy as pie