Convert text to Date type

Heyy,

I need help! I have a table in my database that is having a field containing the text, “created on 12/23/2022” ofcourse the date is different in each record. I need to extract the date and add it the field called “AvDate” this should be of type Date since we need to perform operations for date like > or < 0r =

Thanks

try the plugin unix to date it has a function to convert text to date

1 Like

Just use any arbitrary date (or the current date/time), and modify it accordingly…

i.e.:

Some arbitrary date: change date to (text date): change month to (text month): change year to (text year)

You can get rid of created on using find and replace, then you can extract the values from the text using the :split by operator, and using / as the character to split by (you’ll have to convert each value to a number in order to modify the date)

1 Like

This worked thanks used this plugin.

This topic was automatically closed after 70 days. New replies are no longer allowed.