how to remove time stamp

[#1]

Hi,

I have a question

i have a table which contain two fields ( Sub_Order , Order_Date )

Order_Date are in timestamp format

i want to relate this table date to the calendar via (Order_Date)

but this can't be done because of the timestamp in the order_Date

so,when i select certian sub_order it doesn't reflect in the calendar

How to remove that and make my selection of certian sub_Order affect the Calendar??

Best Regards,

Mona

[lironbaram · Accepted solution]

hei

please check attach example

basicly i used a floor function on the order date field

which remove the hour parts from the filed

[#3]

Thanks Liron

it works