Is there any date function in query which can be used to insert date and time in SAP B1 automatically?.
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.
Julie Jamieson 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