i have a saved search in which i take the date. it...
# suitescriptv
vennila ramasamy
02/16/2023, 8:24 AMi have a saved search in which i take the date. it returns as 09/03/2022, I want this as to display like 09 March 2022, but it displays as 03 september 2022. It swaps month and date. how can i achieve this?
k
karlenigma
02/16/2023, 8:50 AMFormula Text and lookup TO_CHAR
v
vennila ramasamy
02/16/2023, 9:46 AMSorry i dont get it.
k
karlenigma
02/16/2023, 11:16 AMUse a formula text column and use the SQL function TO_CHAR