round up dates

[Anonymous]

Hi all

i'm having a date round up issue

both dates look in the GUI the same but apparently one is bigger than the other

how can i round them up the two dates

Thanks

J

Date((date#(left(Day,12),'MMM DD, YYYY') +Maketime(hour([R_ Time]))),'MM.DD.YY hh:mm')    AS 111

Date (timestamp#(left(Time,16),'YYYY/MM/DD hh:mm'),'MM.DD.YY hh:mm' )                          AS  2222