About Date

building reports webintelligence
1

How to calculate the first day of month and the last day of month?

Thank you very much!

shizhaoying (BOB member since 2009-10-20)

2

What do you mean “How to Calculate”? :?: :? pls discuss further…

Thanks! :+1:

mez19 (BOB member since 2009-08-10)

3

Using LastDayofMonth() function, you can find out the last day.

The first day of the month can be calculated using some tricks like this one.

CD=CurrentDate()
DN=DayNumberOfMonth(CurrentDate())-1
FD=RelativeDate(<CD> ,-<DN>)

Jansi :india: (BOB member since 2008-05-12)

4

How to write the last day of month&#65311;

shizhaoying (BOB member since 2009-10-20)

5

Did you read the responses you have already? The answer has been provided.

Dave Rathbun :us: (BOB member since 2002-06-06)

6

:nopity: thank you![/code]

shizhaoying (BOB member since 2009-10-20)

7

I am a novice,The above answer is only the first day of the contents of the

:cry:

shizhaoying (BOB member since 2009-10-20)

8

Oh, I see, thank you

shizhaoying (BOB member since 2009-10-20)

9

No problem. Going forward, please edit your prior post to add such information instead of posting three posts one by one successively. :slight_smile:

Jansi :india: (BOB member since 2008-05-12)

10

I have just tried,Not possible to calculate the first day of data,
why? :frowning:

shizhaoying (BOB member since 2009-10-20)

11

The first day is always the same. It’s day 1 of whatever month you have. So with today being November, it’s always going to be November 1, 2009 for this month. The answer provided above by Jansi shows you to make up a date by combining the known (the day of the month) with the unknown (the month and year of the selected date).

I understand that you may be having trouble following, but please post the formula you are trying so people can help, rather than just saying it’s not working…

Dave Rathbun :us: (BOB member since 2002-06-06)

12

Thank you everybody! I have achieved 8)

shizhaoying (BOB member since 2009-10-20)