Hi,

I am facing problem when i am inserting date field through IBPM workflow form to the table.

In form i have taken the date data type (which contains date time) is date and in erp-ln table the corresponding date field's domain is UTC (date with time).

When I am inserting in Prologue action by writing insert query its not inserting.
It seems error regarding date conversion.

Do you have any idea how to resolve this ?

Thanks in advance...

for a workaround, convert the date from the workflow into a string and then pass it to the custom table field which is of type String/Varchar.then it will save your date value in string format. Meanwhile i'm also working on the same issue resolution.

Hi,

I am facing problem when i am inserting date field through IBPM workflow form to the table.

In form i have taken the date data type (which contains date time) is date and in erp-ln table the corresponding date field's domain is UTC (date with time).

When I am inserting in Prologue action by writing insert query its not inserting.
It seems error regarding date conversion.

Do you have any idea how to resolve this ?

Thanks in advance...

You can resolve this issue of formatting date as below:-

If you want to get the current date in workflow,you have to take three variables

like v_date (today's date) date type,init_date(Jan 1, 1900 12:00:00 AM) date type and int_date (Integer).

Then use Action set to calculate the date using DateDiff function like
DateDiff (uda.v_date,uda.init_date,"dd") and return it to int_date.

In this way you will get the date you required.