I want to convert timestamp to string, I am able to use the ToString function but I just want the date and not the hh:mm:ss.
ToString(sent_date)
Current Output: 2023-02-28 00:00:00
Required Output: 2023-02-08
I want to convert timestamp to string, I am able to use the ToString function but I just want the date and not the hh:mm:ss.
ToString(sent_date)
Current Output: 2023-02-28 00:00:00
Required Output: 2023-02-08
will it always be in that format YYYY-MM-DD?
If so can you take the substring of the first 10?
substring(toString(sent_date),1,10)
As always easy and to the point solution… simple loved it.
Regards - San
Thanks for sharing this feedback @Sanjeeb2022! Yes, @Max and his team at West Loop are awesome. Grateful for expert answers! @patilmeet7, if Max’s solution works for you, can you mark Max’s reply as “Solution” (check box under his reply)? This will help our community out a lot! Thx!