Replace symbols in date

[TheBadOne]

How to replace the date "31.12.2024" with "31 any_word 2024" in Appsheet bot (set row values)? 12 - there can be any month from 1 to 12.

[Dustman]

Option 1. Change your date type column to a text type column, then in the initial value enter: TEXT(TODAY(), "DD MMMM YYYY).
Option 2. Create a virtual column that uses your date type column as the data source and convert it to the expression above. TEXT([date_column],"DD MMMM YYYY"), then only show it in the views you want using CONTEXT().
TEXT()  https://support.google.com/appsheet/answer/10107701?hl=en
TODAY()  https://support.google.com/appsheet/answer/10108286?hl=en&sjid=6618627236662798096-NA

[Marc_Dillon]

Appsheet doesn't have regex functions, so you're a bit constrained with something like that. You could do this, but it's certainly messy.

INDEX(SPLIT([x],"."),1) & " any_word " & INDEX(SPLIT([x],"."),3)

[TheBadOne · Accepted solution]

Thank you, I spent half a day solving this problem, but I solved it in my own way. Created a virtual columns: [Day] with the value TEXT([Date], "DD")
[Month N] with the value TEXT([Date], "MM")
[Month] with the value IFS(
[Month N]="01", "january",
[Month N]="02", "february",
...)
And after it I was able to use this data further as I want.