Date Format and Time

[adnancanada]

I have date in "20170222" I want this date in "02/22/2017 23:59" , Please help me


I used dateserial function in MS Access

DateSerial(Left([PICKUP_DATE],4),Mid([PICKUP_DATE],5,2),Right([PICKUP_DATE],2))

it works fine. it give me mm/dd/yyyy but I want to add time 23:59 how can I do that.

[ranman256]

Dateserial(....) & " 23:59"

[adnancanada]

Thanks a lot.