Change the date format

[Divyaverma2906]

Can we change the provided format Fri, Jan 8, 2021 date into mm/dd/yyyy format or any date format

[binuacs]

@Divyaverma2906 

Spoiler

[Divyaverma2906]

Hi, 

So you entered the data to input text tool, instead could you use the sheet provided and then apply formula, I tried in my sheet and this isnt working

[binuacs]

@Divyaverma2906 it is working in both cases

Spoiler

[kelsey_kincaid]

Hi @Divyaverma2906 ,

Using the formula tool like @binuacs mentioned should work for you and is the more elegant solution, but I tend to prefer using the DateTime tool because I think it is more user-friendly. Here's an example using the date time tool twice to 1) convert your string into a date and 2) convert your date back into a custom format.