Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Is there any date function in query which can be used to insert date and time in SAP B1 automatically?.

Hi all,

I have a question, some times I have an idea of to insert datetime in SAP B1 query automatically. So is that possible in SAP B1?

Please anyone can help me.

Former Member replied

If you are using Formatted search, just use a SELECT statement to add the value to the field.

To get current datetime stamp would be SELECT GETDATE(). Trigger this on the same field you are using to trigger your other Formatted search.

To update your UDF you should use SAP tools such as DTW not an update query

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question