Date fields showing a time instead?!

[Guest Paul Alexander]

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

[Guest riz]

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

[Guest Paul Alexander]

Hi @riz

 

They're both from the Service Portal

thanks

[Victor]

@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...

[Victor]

@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).

[Guest Paul Alexander]

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?

 

[Victor]

@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)
 

[Guest Paul Alexander]

ok thank you again Victor

As usual you've been a star

[Victor]

@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 )