Avout fabs(),monthend,weekday

[#1]

Hi All,

fabs(MonthEnd(Today())-  WeekDay( MonthEnd(Today())+1 ))

above expression what it will return.

please help me out this issue, And please explain functionality of each expression.

thanks in Advance.

Regards

prathap.

[sunny_talwar]

This is what this expression in returning:

[#3]

Hi Sunny,

Thanks for your reply..

i used same expression what you mentioned but it gave output as  28-Feb-2016 23:59:59.

[Anonymous]

• fabs( x )

Return the absolute value of x. The result is a positive number.

Examples:

fabs( 2.4 ) returns 2.4

fabs( -3.8 ) returns 3.8

• MonthEnd( date [, shift = 0] )

Returns a value corresponding to a timestamp with the last millisecond

of the last date of the month containing date.

Examples:

monthend ( '2001-02-19' ) returns '2001-02-28' with an underlying

numeric value corresponding to '2001-02-28 23:59:59.999'

monthend ( '2001-02-19', -1 ) returns '2001-01-31' with an underlying

numeric value corresponding to '2001-01-31 23:59:59.999'

• today( [ timer_mode ] )

Returns the date from the system clock

• weekday( date )

The result is a number between 0-6 (0=Monday).

• MonthEnd( date [, shift = 0] )

Returns a value corresponding to a timestamp with the last millisecond

of the last date of the month containing date.

Examples:

monthend ( '2001-02-19' ) returns '2001-02-28' with an underlying

numeric value corresponding to '2001-02-28 23:59:59.999'

monthend ( '2001-02-19', -1 ) returns '2001-01-31' with an underlying

numeric value corresponding to '2001-01-31 23:59:59.999'

So your expression will return for example for today(24/02/2016)

date(fabs(MonthEnd(Today())-  WeekDay( MonthEnd(Today())+1 )),'DD/MM/YYYY')= 28/02/2016

MonthEnd(Today())                  = 29/02/2016

WeekDay( MonthEnd(Today()) = 1

For the correct format, you should try:

date(fabs(MonthEnd(Today())-  WeekDay( MonthEnd(Today())+1 )),'DD/MM/YYYY')

[#5]

Hi Sara,

Thanks for your reply.

it is very clear now.

regards

prathap.

[HirisH_V7]

Hi,

check your Date and time using now().

[sunny_talwar]

I guess the difference is due to different weekdays.

Mine is setting WeekDay in the script like this -> SET FirstWeekDay=6;

Yours would be this -> SET FirstWeekDay=7;

[#8]

Hi All,

Thanks for your replies.

[oknotsen]

Please flag helpful replies as Helpful.

If your question is now answered, please flag the Correct Answer.

If not, please let us know with what part of your question you still need help .