on 02-01-2014 6:21 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anil,
what is the backend Database you are using?
Regards,
Javed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create a new object.
Your date object : Date
New Object :
= CONVERT(VARCHAR(10),Date,110)
This will give you date is mm/dd/yyyy format.
Try this.
Check this for the format you need :
Regards,
Javed
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.