null value when converting v_string to date type

[topazz11]

Hello,

I am trying to convert the string to date type but getting null value...and it says the cell has trailing spaces in the date field

Can anyone help??

Thank you,

date

20220103

20220107

20220513

[IraWatt]

Hey @topazz11,

As your string data is not in the default format for a date you will need to use the date time tool or a formula to specify what format the date is in to convert it to a date type:

Any questions or issues please ask :)
HTH!
Ira

[topazz11]

This is what I tried and null value 

[IraWatt · Accepted solution]

@topazz11 your top datetime tool is converting your company code column. It is also converting from the format dd/MM/yyyy your data is formatted as yyyyMMdd (no /). Likewise with your formula tool your format is %y%m%d not %d/%m/%y.

Check these two:

[topazz11]

same issue..

[IraWatt]

Hey @topazz11, you have selected yyyy-MM-dd you need to select yyyyMMdd. your date column does not have any dashes. 

[ddiesel]

Hi @topazz11!

Did  @IraWatt's solution work for you?

[grazitti_sapna · Accepted solution]

@topazz11, as @IraWatt  you have selected yyyy-mm-dd instead of yyyymmdd. Please refer to the screenshot below.

Thanks!