Convert Date Time to Date

[#1]

Hi Guys,

I need to convert my date, (a number like 45302.8333) to date data type, but without the hour.

I using the following. Is there any better way to do it?

Thanks,

Aldo.

Date( num#(PaymentDate) - Frac(PaymentDate), 'DD/MM/YYYY')

[tresB]

Hi,

If your PaymentDate itself has the numeric values, why can't you simply use: Date(PaymentDate,'DD/MM/YYYY')? fraction would not bother you.

[hector · Accepted solution]

Hi, you can use dayname(field), and this will return only the date part

dayname(45302.8333) = 11-01-2024
timestamp(dayname(45302.8333)) = 11-01-2024 0:00:00

So you can see, the decimal part is removed this is something like date(floor(field))

Rgds

[#4]

Thanks