Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Is there a system function to assign a greater than date on the QBE line of a Date column? (e.g. ">

edited Mar 24, 2015 9:56AM in Design Tools & Output Technologies - JDE1 (MOSC) 9 commentsAnswered ✓


I'm looking for a way to assign a greater than today's date in the QBE field of a date column. I'm using a Find/Browse form that on entry in the Post Dialog is Initialize event, I'm assigning to

QC Date = concat(">",SL DateToday)

but the field doesn't take it.

I wonder if this fails because QC Date is a date type and concat() is a text function...? Is there a system function that could be used to accomplish this?

Thanks,

Jorge

(Working on JDE ERP 9.0)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center