I have date in the table with format YYYY-MM-DD. But I want to convert it into DD-MMM-YYYY format. Can anyone please help me I have tried a lot but i am not able to do so.β
For Eg- wants to convert from 2021-04-13 to 13-Mar-2021
I suggest to work with format you have so you can use Date&Time based nodes (I assume you have Local Date column type) and then prior to exporting data convert your column to string using Date&Time to String node and then further manipulate it to format you want using join() and substr() functions.
@ipazin Thanks for reply.
I have tried the given solution but it returns output in DD-MM-YYYY
Whereas I want the output in DD-MMM-YYYY format. Kindly suggest solution for the same.