=[Sheet Column]@row = "" not working (from Date type)
So I have a Last Updated column that is a Date type, then I created a temp column just to test this where I apply the formula [Last Updated]@row + "" to a cell in temp and i just get the same value I have in Last Updated. I've tried changing the column type for temp to both Date and Text/Number
Best Answer
-
Hi @zcornute
I believe I commented on your other post, too.
The reason you're seeing the exact same value in your "Temp" column is because the "Last Updated" column is a regular Date type of column which can only house a date. If you're looking to bring in a Time value with that date, the only Date columns that have time associated are the two System Columns: Created and Modified.
See: Use a System Column to Automatically Add Information to a Row
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @zcornute
I believe I commented on your other post, too.
The reason you're seeing the exact same value in your "Temp" column is because the "Last Updated" column is a regular Date type of column which can only house a date. If you're looking to bring in a Time value with that date, the only Date columns that have time associated are the two System Columns: Created and Modified.
See: Use a System Column to Automatically Add Information to a Row
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks @Genevieve P.! I created this discussion because I wasn't sure how long it would take for someone to see my comment on that other one since it was a little dated haha. I'm guessing that the example provided in the other discussion was based off a System Date Column and not a Date Column which caused some confusion on my part.
The other discussion for anybody that comes across this and is wondering:
-
No problem at all! I'm glad you were able to figure out the different column-types. 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
