Change date

[SahilArora3139]

I want to change date format:

with select tool i can see my type is string

i want to convert string into date

date in sheet: 11-Feb-23

format i want- 2023-02-11

[glenebb]

Use the DateTime tool in the Parse section. That'll change it from a string to a date type

[SahilArora3139]

Tried using that can you help me out with formula tool

[glenebb]

[SahilArora3139]

My format is

11-Feb-23

desired format:

YYYY-MM-DD

2023-02-11

[glenebb]

Your formula would be dd-MMM-yy (or you could select the dd-Mon.-yy option in the list). This will then create a new field which defaults as DateTime_Out. You can either rename it in the DateTime tool or use a select afterwards. See screenshot above

Hope this helps

[neilgallen]

using a formula tool the most direct option is to use datetimeparse:

datetimeparse([field],"%d-%B-%y")

where:

%d - two digit date

%B - short abbreviation of the month

%y - two digit year

you can use this in a formula and then change the field type after with a select tool. This prevents the need for an additional column.