convert today to number

[ali_hijazi]

Hello

you know that in Qlik num(Today()) returns 42313 (if today is 11/5/2015)

How can I get the number representation of today at 12 PM?

[jonathandienst]

This is the simplest:

=Num(Today() + 0.5)

[sunny_talwar]

You can use Num(Now())

[jonathandienst]

Or if you prefer:

=Num(Today() + Time#('12:00:00'))

[sunny_talwar]

for number, may be this:

Num(Today()) + 0.5

[Anonymous]

num(Today()) will remain same for the day..

num(now()) will be changing as time changes...

[Kushal_Chawda]

try,

=Today()+MakeTime(12,0,0)

[ali_hijazi]

this is it cause actually I might want to see the number representation of today at 3:15 PM for example