How would you format a token that returns a datetime to mm/dd/yyyy?

Hello Collin,

You'll want to use Custom SQL as the data source in order to accomplish this.

You can return a column that stores a date value, let's name the column "DateSubmitted" just for this example:

Select
Convert(char(10), DateSubmitted, 101) As TheDate

Or if you just want the current date:

Select
Convert(char(10), GetDate(), 101) As TheDate

If you're using Dynamic Forms instance as the data source you'll need to go to your Dynamic Form and add a new Question with a SQL Default value of:

Select
Convert(char(10), GetDate(), 101) As DefaultValue


Then regenerate columns for your Dynamic View to show the new Dynamic Forms column.

Let me know if you have any questions.

Thanks,

Ryan

Thanks, kind of thought that was the way to go. Appreciate it.

Glad to be of assistance.

Hope you have a great day!

-Ryan