Convert Date into 5 digits like in excel and vice versa
Hi Team,
as you can see that column A is date format and col B is Text format
I would like to seek for your advice on how to convert the date to 5 digits numbers like in excel when we change format of date to text and vice versa.
is there a node that can serve this purpose? if not, is there a way we can achieve this with combined nodes?
your advice is really appreciated