Convert date time to num

[anuradhaa]

Hi,

I have below expression and i want to convert it num()

Please help

date(ReloadTime() ,'YYYY-MM-DD') &'  '& time(MakeTime(6,30),'hh:mm')

Thank You

[Chanty4u]

hi

use Alt() fun,

try lik dis

hope this helps you

Alt(Date#(DateField, 'd/M/yyyy'), Date#(DateField, 'M/d/yyyy'),Date#(DateField, 'd/MMM/yyyy'), ...............

)

thanks

Suresh

[Anonymous · Accepted solution]

try this:

=num(timestamp#(date(ReloadTime(),'DD/MMM/YYYY')&' '&Time(MakeTime(6,30),'hh:mm'),'DD/MMM/YYYY hh:mm'))

[maxgro]

floor(ReloadTime()) + MakeTime(6,30)

[anuradhaa]

if i used floor(ReloadTime()) it use both date n time. but i want only the date

[tresesco]

The reverse is true. If you use floor(), it gives you the integer part of a timestamp and that doesn't contain time but the date only. The fraction part of a timestamp is responsible for time.