How to transform 3 fields numbers in a single Date Field?

Discussion created by eduardohomem on Dec 2, 2018
Latest reply on Dec 2, 2018 by comment

I made an error. The date in my database has 3 number fields.

One for "Day", another for "Month" and a third for "Year".

Now I want to create one single Date Field.

My database has more than 1000 records.

What can I do to avoid enter 1000 times in a single Date field the 3 fields Day/Month/Year of each record?

Thank you for your help