Hi,
I have chosen the field type as date as shown as screenshot below and it show the null result.
May i know how can we fix this?
Solved! Go to Solution.
Hi @SH_94 ,
Can you post your workflow with a mock up of your data showing the exact format in which the date field is coming in originally?
M.
@SH_94 ,
mate, you are creating the issue. On the select tool, you have explicitly changed the data type of the Transdate from VString to Date, this is the issue. make the change after the formula tool and that should work.
Thanks a lot again for your help
Hi @ImadZidan,
May i know what formula i should use if there are two format inside the data as show below?
Hi @SH_94,
Is this what you are looking for?
If it solves your issue please mark it as a solution
Hi @grazitti_sapna
If you look at the output , the date for second row is different . Meaning the year from input is 2019 but the output is 2022
Yes. This is what i looking for but may i know how to fix it ?
Hi @ Sapna,
I have tried using the formula that shared with you but it give the output as shown below.
For those with 14/02/2020, it has been successfully changed it to 2020-02-14. But for those date original in the format like 2021-04-15, it change to number as shown in the screenshot below. May i know how should i change it accrodingly?