# How To Get Value of Today Date **URL:** \ **Category:** Ask for Help\ **Tags:** date-math\ **Created:** [May 8, 2024, 2:03am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168 "2024-05-08T02:03:17Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Muhammad\_Iqbal1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muhammad_iqbal1/32/38548_2.png) [@Muhammad\_Iqbal1](https://community.glideapps.com/u/Muhammad_Iqbal1)\ **Post date:** [May 8, 2024, 2:03am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/1 "2024-05-08T02:03:17Z")
How to Get Value of Today Date. Example, today 8 May 2024, I want to get the value 45420. ---
**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:** [May 8, 2024, 3:10am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/2 "2024-05-08T03:10:44Z")
Can you explain what each number represents in 45420? I’m having trouble understanding how it relates to today’s date. ---
**Author:** ![raajkumars](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raajkumars/32/74046_2.png) [@raajkumars](https://community.glideapps.com/u/raajkumars)\ **Post date:** [May 8, 2024, 3:16am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/3 "2024-05-08T03:16:38Z")
I believe you want to date converted to Excel’s date value, which is a serial number that represents the number of days elapsed since January 1, 1904. You can either use an Excel column type and use the formula **DateValue** or you can use Glide’s date functions for this. ---
**Author:** ![Muhammad\_Iqbal1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muhammad_iqbal1/32/38548_2.png) [@Muhammad\_Iqbal1](https://community.glideapps.com/u/Muhammad_Iqbal1)\ **Post date:** [May 8, 2024, 3:27am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/4 "2024-05-08T03:27:42Z")
exactly what @raajkumars said, I want to converted date on glide table to excel date value. ---
**Author:** ![Muhammad\_Iqbal1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muhammad_iqbal1/32/38548_2.png) [@Muhammad\_Iqbal1](https://community.glideapps.com/u/Muhammad_Iqbal1)\ **Post date:** [May 8, 2024, 3:29am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/5 "2024-05-08T03:29:10Z")
excel DateValue can’t work, Glide Table Date Function I don’t know how to use it because Luxon documentation is missing ---
**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:** [May 8, 2024, 3:31am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/6 "2024-05-08T03:31:35Z")
Use this in a math column and replace ‘Date’ with Now. `FLOOR(Date)` ![Screenshot_20240507-223324](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4cbab58a735ed5449342b2d2e0cd3992001d4410.png) ---
**Author:** ![raajkumars](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raajkumars/32/74046_2.png) [@raajkumars](https://community.glideapps.com/u/raajkumars)\ **Post date:** [May 8, 2024, 3:45am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/7 "2024-05-08T03:45:48Z")
**Using Date Difference function** ![Screenshot 2024-05-08 001924](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f171457272acf121f43b0698b8b9e80ea8bb39b5.png) **Using Excel Date Value function** ![Screenshot 2024-05-07 235016](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/3114ba6595475f3e7b404aa96e5828ca9e53b58e.png) ---
**Author:** ![raajkumars](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raajkumars/32/74046_2.png) [@raajkumars](https://community.glideapps.com/u/raajkumars)\ **Post date:** [May 8, 2024, 3:52am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/8 "2024-05-08T03:52:52Z")
> Use this in a math column and replace ‘Date’ with Now. > FLOOR(Date) **Excellent suggestion!** I would recommend using this because this is simple math function that is not experimental. ---
**Author:** ![Muhammad\_Iqbal1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muhammad_iqbal1/32/38548_2.png) [@Muhammad\_Iqbal1](https://community.glideapps.com/u/Muhammad_Iqbal1)\ **Post date:** [May 8, 2024, 4:32am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/9 "2024-05-08T04:32:49Z")
Thank You for this solution ---
**Author:** ![Muhammad\_Iqbal1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muhammad_iqbal1/32/38548_2.png) [@Muhammad\_Iqbal1](https://community.glideapps.com/u/Muhammad_Iqbal1)\ **Post date:** [May 8, 2024, 4:33am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/10 "2024-05-08T04:33:00Z")
Thank You for this solution too ---
**Author:** ![Muhammad\_Iqbal1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muhammad_iqbal1/32/38548_2.png) [@Muhammad\_Iqbal1](https://community.glideapps.com/u/Muhammad_Iqbal1)\ **Post date:** [May 8, 2024, 4:34am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/11 "2024-05-08T04:34:34Z")
@Jeff_Hager I have new problem, how to convert text from **single value** to Value. I have use Excel Function “Value(A1)” it doesn’t work ---
**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:** [May 8, 2024, 4:37am UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/12 "2024-05-08T04:37:29Z")
So you are trying to convert text into a number? What is your use case? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 8, 2024, 11:22pm UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/13 "2024-05-08T23:22:42Z")
> [@raajkumars](#): > > that is not experimental. If you mean this by finding it under the “Experimental” folder, I don’t think you need to worry much about it. Those has been Experimental for like years. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 15, 2024, 11:23pm UTC](https://community.glideapps.com/t/how-to-get-value-of-today-date/73168/14 "2024-05-15T23:23:16Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.