System Date comparison with Opening Date not working

[Former Member]

Hi,

I have a requirement where only want to search the records for which Opening Data (Main Table Field) is equal to System Date.

I tried using opening date = system date also opening date - system date = 0 but both not working.

I am working on MDM 7.1 SP4.

Please suggest any solution to meet this requirement.

Thanks in advance.

Vikas

[Former Member · Accepted solution]

Hello Vikas,

Try below validation expression & let us know if it works...

LEFT(SYSTIME(0),10) = LEFT(Opening Date,10)

Here SYSTIME is Standard System Time function & Opening Date is your main table field....

Thanks & Regards,

Maheshwari

[Former Member]

Hi Vikas,

Systime(0) gives you current date,you can use this function to get the result.

Refer to pg no 9-10 of the following document this should the issue:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b025fab3-b3e9-2910-d999-a27b7a075...

Thanks,

Ravi