You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to default date DFF to today's date or System Date

Accepted answer


Content (please ensure you mask any confidential information):


Requirement is client wants a new field "PO Date" to be opened at PO Header level. The value for this field should be defaulted to system's date or today's date and if user wishes to change the date then s/he can select the value and change. Otherwise, it should be defaulted to today's date value.

I can see there is an option in DFF under 'Initial Default' but unable to figure out how to use it to default to today's date. Can you please share if there are any sql queries available to achieve this?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!