BusinessObjects Board

First day of the current year

building reports
#1

Hi All

Looking to calculate first day of the year pls.

thanks
Sims

#2

All you need to do is construct a string that is the first day of the year and then convert it to a date. What attempts have you made at this?

Noel

#3

I’d probably make an object in the universe, but not, you could use this - I’m sure there are simpler ways, but hopefully this should work
=ToDate(Concatenation(“01/01/”;FormatDate(CurrentDate();“yyyy”));“dd/mm/yyyy”)

1 Like
#4

Be sure to replace those curly quotes with straight quotes if you copy the formula.

2 Likes
#5

Ah Good to know! Cheers

#6

excellent, many thanks