this is not a real bug but maybe you could fix it in a next release.
Often when I import a database table (from postgresql) in which the first column is an “Id” with integer data type, the result table made its format as a date.
Today i was put in my project a simple Parameter to Table action and same problem occurred. I think that integers that start from 25570 (e.g. linux date 1970 Jan 01) are automatically recognized as date.
Hi AndreaM and thanks for answered my issue.
I know that I can change the format, but I would rather that by default the numbers had no format.
In fact, often the wrong format is inherited between the actions making it inconvenient to go and modify it
I am not @dgudkov , but I can try to answer your question. In EasyMorph, there is a distinction between the ‘display format’ and the ‘real data representation’. The ‘display format’ refers to how the data is shown in the EasyMorph Desktop app / workflow view, while the ‘real data representation’ refers to the actual value of the data.
EasyMorph doesn’t have a specific ‘Date’ type. Instead, all dates are internally stored as numbers in what is called the OAdate format. This format represents a date as a floating-point number, where the integral component represents the number of days before or after midnight on December 30, 1899, and the fractional component represents the time on that day divided by 24.
Apologies, @carlo.nigro, I misinterpreted your message earlier… To clarify, you want the column to explicitly stay the number, not the date? In this case, you could try instead of ‘No format’ pick explicit number format for your invoice_doc... column, like
Hi @olysak and thanks for reply!
My problem is a bit more complicate and I will try to explain it better.
As I shown in the first table, mi column Invoice_Doc originally is a database id (integer). So if I store it in Salesforce using directly EasyMorph interface, all works correcly.
But if I change column format (as happens during my nigtly scheduled process), last action does not use the stored number placed behind the column but the front formatted number, so Salesforce raise correctly an Exception.
Could you please try specifying the column format explicitly by selecting ‘1000’ from the dropdown list, as shown in my previous screenshot? You mentioned that changing the column format caused the Invoice_Doc format to change. However, it’s not clear why this format changes at all, as this should not happen automatically unless you select the ‘No format’ option