Convert Timestamp (DateTime) to Date only in a Virtual Column

[Scott_Hall]

I have a virtual column that i need to give me the date (date only) for the date the form was completed. If I use Today() it will always be the current date correct? So what is the correct way to do this?

I have a timestamp column (DateTime). Is it possible to make the virtual column equal the timestamp column but converted to date only?

[Bahbus · Accepted solution]

DATE([TimestampColumn])

[Scott_Hall]

Works perfectly. Thank you very much!

[Skip2MiLu]

Is there way i timestamp can return a date only without needing a virtual column?

[Steve]

I’m not sure I understand your question.

To generate a DateTime timestamp, use NOW().

To generate a Date timestamp, use TODAY().

To generate a Time timestamp, use TIMENOW().

To convert a DateTime value to a Date, use DATE().

See also:

help.appsheet.com

DATE()

Date from Date, DateTime, or Time

help.appsheet.com

NOW()

Current date & time

help.appsheet.com

TIMENOW()

Current time

help.appsheet.com

TODAY()

Current date

[Skip2MiLu]

Appologies for being a bit unclear.

I am using a ChangeTimestamp column type for column [Task Complete Date] where [Task Status] = “Task Complete”

I was hoping to only return date format and not datetime format without using another virtual column to do so.

[Steve]

I don’t believe that’s possible.

[Mike_T]

Steve:

To convert a DateTime value to a Date , use DATE() .

Added a virtual column: “Date Display Removed”, in the formula I put if(ISBLANK([Display Removed]),“Active”,DATE([Display Removed])). I’ve designated the type of my VC to be Text, because if I use Date, it won’t show it.

Display Removed column is type Date, however it contains “Active” by default until the user adds the date using an Action.

The VC is still showing the time even though the Display Removed column is of Type Date and the actual value in the cell is just a date mm/dd/yyyy format.

[Suvrutt_Gurjar]

Mike_T:

Added a virtual column: “Date Display Removed”, in the formula I put if(ISBLANK([Display Removed]),“Active”,DATE([Display Removed])).

In the expression above, the column name is [Display Removed] In the picture shared, there are columns by name [Date Display Installed] and [Date Display Removed]

Could you please mention, if [Display Removed] a third column or same as [Date Display Removed]

[Mike_T]

“Display Removed” column is the real column in the table. The value in the column is either “Active” by default or a date that is updated using an action. It’s type is Date.

“Date Display Removed” is a virtual column I’ve added trying to show just the date of the “Display Removed” column using the formula above.

If I don’t need the VC to just show the Date of the “Display Removed” column, I’m good with that. But because it has “Active” as a value and is type Date, it won’t display correctly.

[Suvrutt_Gurjar]

I believe the column type be text rather than date because the word"Active" is text type. So IF() has one argument of TEXT type and another DATE() type.

You could make the VC of text type and try the following expression

IF(ISBLANK([Display Removed]),“Active”, TEXT([Display Removed], “MM/DD/YYYY”))

Or even below expression

IF(ISBLANK([Display Removed]), “Active”, TEXT([Display Removed]))

If you are using that VC in date calculations again, you could type cast it with date again such as DATE([Date Display Removed])