Dreamcatchers
Posts: 120
|
| Posted: 05/14/2016, 5:05 PM |
|
I created a calendar from the builder and it looks great.
Problem is, it does not display any of the records in the events table.
I have done this before but now an stumped, total brain fart.
I have check my selection criteria and event removed all selections and still not records show up.
Any idea what I am missing?
_________________
Training and LMS Developer |
 |
 |
eratech
Posts: 513
|
| Posted: 05/18/2016, 11:46 PM |
|
Date formats in the DB not translating into the date range it is showing?
E
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|
Dreamcatchers
Posts: 120
|
| Posted: 05/21/2016, 3:18 PM |
|
My date format in the database for startdate is datetime2(0)
That is working for all programs except when I tried using the calendar builder.
I have done this in 4.3 and 5.1 of CCS with the same results.
_________________
Training and LMS Developer |
|
|
|
Dreamcatchers
Posts: 120
|
| Posted: 06/01/2016, 10:39 PM |
|
YesSoftware helped on this one.
I change the date format in SQLServer 2010 to datetime2(0). This reduces space where I only want a date and no precision on time.
Change the type back to datetime made everything work nicely.
_________________
Training and LMS Developer |
|
|
|
Dreamcatchers
Posts: 120
|
| Posted: 06/01/2016, 10:39 PM |
|
YesSoftware helped on this one.
I change the date format in SQLServer 2010 to datetime2(0). This reduces space where I only want a date and no precision on time.
Change the type back to datetime made everything work nicely.
_________________
Training and LMS Developer |
|
|
|
eratech
Posts: 513
|
| Posted: 06/08/2016, 11:51 PM |
|
Good to know that the newer format has that effect. SQL updates keep me looking at what the new types might offer but I find myself sticking with the old favourites of varchar, datetime, and int/bigint/tinyint.
E
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|
