todate

building reports webintelligence
1

Hello,

I have a date object. I need to convert each date value to show mid of the respective month. I used the following formula but it is showing #error.

=ToDate(“15”+"-"+Month([Date])+"-"+Year([Date]), “dd/mm/yyyy”)

Is the any function to get mid of the month like we have Lastdayofmonth to get last date of the month?

Thanks in Advance

pushkar :india: (BOB member since 2006-03-10)

2

Hi,

Try a formula like this:

=ToDate(FormatDate([date];"yyyyMM")+"15";"yyyyMMdd")

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

In report level your Variable formula will be
=RelativeDate(CurrentDate();-(DayNumberOfMonth(CurrentDate())+15)

Rajubollas :india: (BOB member since 2009-09-04)

4

Hi Marek Thanks for quick response. Will try it and let you know the output.

Thanks again!

pushkar :india: (BOB member since 2006-03-10)