cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate Year Start Date Sales based on Current Date?

chandrasekhar6
Participant
0 Kudos

Hi All,

How to calculate Year Start Date Sales based on Current Date in Webi.

Please share your valuable inputs.

Thanks,

Chandra.K

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Chandra,

So you are asking if today is 21st June 2016 the O/P should be 1st Jan 2016?

If that is so then below code should give you expected result.

=ToDate("01/01/"+FormatNumber(Year(CurrentDate());"##");"MM/dd/yyyy")

Regards

Niraj

chandrasekhar6
Participant
0 Kudos

Hi Niraj,

Thank you so much your quick response..

Thanks,

Chandra.K

Answers (0)