num of date issue

[Anonymous]

When i use NUM(Date(WEEKEND(LOAD_DATE),'MM/D/YYYY')) I am getting value with decimal i.e 42708.999999988

But when i pass the value of Date(WEEKEND(LOAD_DATE),'MM/D/YYYY') directly i.e 12/4/2016 by hardcoding

NUM('12/4/2016') i get whole number 42708.

Could you please let me know how can i avoid decimal with first expression, because of this bug i am getting one value extra for all the count.

[MK_QSL]

Try

NUM(Date(WEEKEND(Floor(LOAD_DATE)),'MM/D/YYYY'))

[MK_QSL]

You can simply write

Floor(LOAD_DATE)

also

[Anil_Babu_Samineni]

Or may be Number format define

NUM(Date(WEEKEND(LOAD_DATE),'MM/D/YYYY'),'##0')

[sunny_talwar]

I think manish weekend gives a timestamp instead of date, so having the Floor after Weekend should fix the issue

Num(Floor(WeekEnd(LOAD_DATE)))