Guest Paul Alexander Posted June 13, 2017 Share Posted June 13, 2017 Hi One of our prog captures being used on our Portal is showing some strange behaviour. One of the questions is 'what datewill someone start and finish', which is obviously set to a date field. On MY portal it shows correctly, but one other peoples' portals, this shows as something else...... I've asked users to try Chrome and Internet Explorer, and it's the same on both...so what have I done wrong!? thanks Link to comment Share on other sites More sharing options...
Guest riz Posted June 13, 2017 Share Posted June 13, 2017 Hi, @Paul Alexander Thank you for your post! Does this screenshot taken from customer portal or service portal? I will try to replicate on my dev instance. Thanks, Riz Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted June 13, 2017 Share Posted June 13, 2017 Hi @riz They're both from the Service Portal thanks Link to comment Share on other sites More sharing options...
Victor Posted June 13, 2017 Share Posted June 13, 2017 @Paul Alexander 18 minutes ago, Paul Alexander said: I've asked users to who are these users? (id's) ... you can send this info in a PM if you like for privacy reasons... Link to comment Share on other sites More sharing options...
Victor Posted June 13, 2017 Share Posted June 13, 2017 @Paul Alexander ... do you import the basic users from somewhere? How are the users created (e.g. the ones you mentioned to me for example) The issue occurs because the users have an invalid date format set against their profile. If you look at the user profile in admin tool you will see the data format field empty. But this is not actually empty, it displays as empty because it contains a value not recognised by Hornbill. You can see this if you look at the user record in the database: that date format is dd:mm:yyyy. Quick fix, ask the affected users to change their date format in their profile (or change it yourself in admin tool) and, if you import the users from somewhere else (like AD), make sure you populate a valid date format for the imported users (by valid format I mean a format accepted by Hornbill). Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted June 13, 2017 Share Posted June 13, 2017 Thanks @Victor To save me looking (cos I'm a little lazy!!) what format does Hornbill accep for dates in the style of 01 Aug 2017 please? Link to comment Share on other sites More sharing options...
Victor Posted June 13, 2017 Share Posted June 13, 2017 @Paul Alexander I do not know how is stored... I think is: dd MMM yyyy but not 100% sure... all accepted formats are visible in the drop down list, you can assign one and then have look how is stored in the DB... (you can run a quick report on h_sys_accounts) Link to comment Share on other sites More sharing options...
Guest Paul Alexander Posted June 13, 2017 Share Posted June 13, 2017 ok thank you again Victor As usual you've been a star Link to comment Share on other sites More sharing options...
Victor Posted June 13, 2017 Share Posted June 13, 2017 @Paul Alexander I've been called legend, epic... so... star is fine too... I guess... (jokes aside, we are happy we can be of assistance and thank you for the appreciation ) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now