# Date stamp **URL:** \ **Category:** Ask for Help\ **Created:** [February 10, 2020, 10:10am UTC](https://community.glideapps.com/t/date-stamp/4455 "2020-02-10T10:10:40Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![112](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/112/32/3116_2.png) [@112](https://community.glideapps.com/u/112)\ **Post date:** [February 10, 2020, 10:10am UTC](https://community.glideapps.com/t/date-stamp/4455/1 "2020-02-10T10:10:41Z")
is there a way to add the date when ever a user sign up. when a new user sign up is there a way to add a date stamp? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 10, 2020, 11:34am UTC](https://community.glideapps.com/t/date-stamp/4455/2 "2020-02-10T11:34:13Z")
The app:logins sheet contains a timestamp whenever a user signs in to a new device or is required to enter a new pin. Unfortunately the date is in a string format instead of date, so it will need to be converted: > [@Date formatting](https://community.glideapps.com/t/date-formatting/2612/2): > > I don’t think Glide is saving it as a true date value. It’s appears to just be text. Try this formula. It strips out the T and Z, then converts it to a date value which can be reformatted using TEXT: =TEXT(DATEVALUE(MID(A2:A,1,10)) + TIMEVALUE(MID(A2:A,12,8)), "DD/MM/YYYY") ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 10, 2020, 2:04pm UTC](https://community.glideapps.com/t/date-stamp/4455/3 "2020-02-10T14:04:49Z")
Correct. The =TEXT() formula in Sheets is a lifesaver. I’ve been using it in nearly all of my apps lately. Perfect for converting numerals to strings, timestamps to date/day/weekday values, etc.