Skip to Content
Former Member
Feb 12, 2007 at 04:22 PM

Concatenating date & time & passing it to a timestamp field.


Hi all,

In CRM i have a entry for a particular <b>04/25/2002 19:11:46</b> from the table CRMD_ORDERADM_H

I want to take only a date from the user in the selection field get this entry adding 00:00:00

& 23:59:59 in ranges so that i can find entries for the complete day as the user doesn't knows the exact time so entries for that particular date will have to be displayed.

I have two options using concatenate & using function module

could u please help me with the code, I AM MORE INTERESTED IN USING CONCATENATE.......thanks in advance.