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
@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, as @IraWatt you have selected yyyy-mm-dd instead of yyyymmdd. Please refer to the screenshot below.
Thanks!
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
This is what I tried and null value
same issue..
Hey @topazz11, you have selected yyyy-MM-dd you need to select yyyyMMdd. your date column does not have any dashes.
Hi @topazz11!
Did @IraWatt's solution work for you?
