Time Filter

resume

I have two fields in Table. One is posting date and another one is Time of Issue.

I want to filter records from today 7.am to Tommorw 7.00 A.m.

Kindly suggest resolution.

kine

You cannot. You need to divide it into two steps (today, 7 to midnight, tomorrow midnight to 7) or create datetime field and fill with the values and filter over it.

resume

Its working fine. Thank You.

One more query. How I can Concanate "Posting Date" and "Time Of Issue" fields in one DateTime field.Posting Date is Date field and "Time Of Issue" is Time fields.

e.g Posting Date := 061211D;
TIme Of Issue := 7.00 A.M

New Field (DateTime field) := "Posting Date" + "Time OF Issue"


When I assign Time of Issue it gives error that one datatype is time and another is integer.

Kindly Suggest solution.

kine

See CREATEDATETIME for more...