Hi @Srikanth Thota ,
Thank you for posting query in Microsoft Q&A Platform.
As per my understanding you are trying to take a column which contains dates and want to generate integer from it in format yyyyMMdd
. Please correct me if I am wrong.
I see that you mentioned your column name in single quotes. If you do that it comes string not a column. So you should consider removing single quotes there.
toInteger(toString(toDate('modified', 'yyyy-MM-dd HH:mm:ss'), 'yyyyMMdd'))
your expression. If you observe here column name modified
is inside single quotes.
Please check below screenshots for better idea.
Hope this helps. Please let us know if any further queries.
-----------------
Please consider hitting Accept Answer
. Accepted answers help community as well.