How To Get Value of Today Date

[Muhammad_Iqbal1]

How to Get Value of Today Date. Example, today 8 May 2024, I want to get the value 45420.

[Jeff_Hager]

Can you explain what each number represents in 45420? I’m having trouble understanding how it relates to today’s date.

[raajkumars]

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.

[Muhammad_Iqbal1]

exactly what @raajkumars said, I want to converted date on glide table to excel date value.

[Muhammad_Iqbal1]

excel DateValue can’t work, Glide Table Date Function I don’t know how to use it because Luxon documentation is missing

[Jeff_Hager]

Use this in a math column and replace ‘Date’ with Now.

FLOOR(Date)

[raajkumars]

Using Date Difference function

Using Excel Date Value function

[raajkumars]

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.

[Muhammad_Iqbal1]

Thank You for this solution

[Muhammad_Iqbal1]

Thank You for this solution too

[Muhammad_Iqbal1]

@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

[Jeff_Hager]

So you are trying to convert text into a number? What is your use case?

[ThinhDinh]

@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.