Odd Num of Date

[wonkymeister]

Guys,

shouldnt a num of date always be a flat int? ie 44773 and not 44773.999999988?

LET vPACEND = num(if(num(day(Today())) <25 , Date(MonthEnd(AddMonths(Today(),-1))) , Date(MonthEnd(Today()))));

the value of vPACEND in a text box ie DATE(vPACEND ) is 44773.999999988

cheers

[PrashantSangle · Accepted solution]

hi

it is because you are using monthend()

AFAIK, it will gave date on timestamp format. and because of that you are getting decimal value.

by default num() only convert the value into numeric format as it is, if want to rounded value then use num(field,'#0') or use floor() to round it.

Regards,

Prashant Sangle

[wonkymeister]

Brilliant, thanks for help

[MarcoWedel]

more specific:

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...