Woohoo!
Month(), Day(), Year()
Now we just need hour, minute and second?
16 Likes
You give people a Year, they’ll ask for a Second!
15 Likes
Seriously. This is super helpful!
3 Likes
Oh…and Weeknum()! I use this ALL THE TIME for weekly records, logs and leaderboard!
7 Likes
All this new date format options are super helpful! Thanks!! 
2 Likes
@yinon_raviv Now you can use this for your 100% Glide Sheets app.
2 Likes
This shouldn’t be a thing. Are you sure this is not a Glide Table?
1 Like
Sorry @Robert_Petitto
Is that pretty Month column getting the value from Date column?
That’s what I really need …, not independent date values with different formats in different columns…
Yep! Getting it from the date column!
Ah. It was a Glide table. 
1 Like
This is great
Not posible using google sheets? How do you do that? How do you call the value? Could I see the insights of the month. column for example?
Thanks. @Robert_Petitto
Just call month(X) and replace X by the datetime column.
But in excel? This wouldn’t be new…
No you do this in a math column.
1 Like
+1 for WEEKNUM()
1 Like
If it only came last week 
1 Like
Thanks @ThinhDinh
Seems that date maths are not working for me…
I’m using google sheets.
Missing something?
Probably there’s a bug going around with the math column. You can try refreshing your editor tab.
