Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DISC Assessment Date showing 01/01/0001 #828

Closed
ElimAdmin opened this issue Feb 4, 2015 · 5 comments
Closed

DISC Assessment Date showing 01/01/0001 #828

ElimAdmin opened this issue Feb 4, 2015 · 5 comments
Assignees
Labels
Status: Confirmed It's clear what the subject of the issue is about, and what the resolution should be. Type: Bug Confirmed bugs or reports that are very likely to be bugs.

Comments

@ElimAdmin
Copy link

On the DISC results page (361), the Assessment Date is showing as 01/01/0001, despite being saved in the data. This may be unique to me because I had to manually create this attribute and may have the wrong date format?

I also wonder if 'LastSaveDate' might be better named 'DISCLastSavedDate' - I can just see someone trying to use this generic attribute name for some other purpose.

discassessmentdate

discassessmentdateattvalue

@mkinyon
Copy link
Contributor

mkinyon commented Feb 5, 2015

I ran into the same issue when inserting a date attribute in SQL. It seems that the format needs to look like this (yyyy-mm-ddThh:mm:ss.mmm) for it to work correctly. I have used the below SQL to format my dates in that format:

SELECT convert(varchar, yourdatevalue, 126)

@arranf
Copy link
Contributor

arranf commented Feb 5, 2015

Per "I also wonder if 'LastSaveDate' might be better named 'DISCLastSavedDate' - I can just see someone trying to use this generic attribute name for some other purpose." that was suggested in #769

@ElimAdmin
Copy link
Author

Thanks @mkinyon.
Here are the attribute values as they have been saved by the DISC assessment workflow:

discassessmentdateattvalue2

I manually edited the date format for me to "2015-01-31" - this now displays correctly on the DISC profile page (and on the extended attributes page).
All other dates show as 01/01/0001 (and do NOT display on the extended attribute page correctly).
Note that the last save date is being written in two DIFFERENT formats (month/day/year time PM / day/month/year/time p.m.) by the DISC workflow process.

I think the DISC workflow should be writing the LastSaveDate in the YYYY-MM-DD format but isn't.

@nairdo
Copy link
Member

nairdo commented Feb 6, 2015

We've renamed that attribute "DISC Last Save Date". We've also found the problem where the the DiscService is not formatting the date string in the ISO 8601 format. We'll fix that too.

@nairdo nairdo added Type: Bug Confirmed bugs or reports that are very likely to be bugs. Status: Confirmed It's clear what the subject of the issue is about, and what the resolution should be. labels Feb 6, 2015
@nairdo nairdo self-assigned this Feb 6, 2015
@ElimAdmin
Copy link
Author

@nairdo Great, thanks Nick.

@nairdo nairdo closed this as completed in 3ad06de Apr 13, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Status: Confirmed It's clear what the subject of the issue is about, and what the resolution should be. Type: Bug Confirmed bugs or reports that are very likely to be bugs.
Projects
None yet
Development

No branches or pull requests

4 participants