Skip to Content
0
Former Member
Feb 01, 2014 at 06:21 AM

Error while converting yyyyMMdd to date in universe

560 Views

Hello

We recently migrated from BO 3.1 to 4.1. While converting a character format of date from yyyyMMdd to date in unuverse we used to use the following convert(date,@Select(Table\Date)). Bud it it is showing the following error.

To avoid this incompatibility, your data of the type 'Char' must be presented according to the Date format ''mm/dd/yyyy HH:m:s'', for example, '02/01/2014 11:50:59'.

Is there any solution??

Thanks

Anil