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

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?

DATE([TimestampColumn])

2 Likes

Works perfectly. Thank you very much!

1 Like

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

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:




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.

I don’t believe that’s possible.