How to clear time/date

How To
1

I’m getting this date/time, and i want to add it to google sheet like “10:00 am 10 jul”
What I mean is to make it clear
SCR-20250705-mjab

EDIT: add tools + compose a sting and select time thing then do something and done

1 Like
2

Hey Rishad,

is that a date type variable already? Then you can use the formatDate() function to change it to whatever you want.

And if its not, then use the parseDate() first to change it to a date variable.