Image Date doesn't display in same format as all other dates

[davepusey]

Ran this SQL Query...


UPDATE [dbo].[tblAssetCustom]
SET [LastFullimage] = CONVERT(datetime,'2013-02-13 13:08:56',120)
WHERE [AssetID] IN
(
SELECT [AssetID]
FROM [dbo].[tblAssets]
WHERE [AssetName] = 'ASC1143'
)



And it's gone into the database ok (see attached)

But on the web interface the date is not being displayed in the same format as all the other dates (see attached)

Any ideas?

[Hemoco]

Within the next few weeks. We are currently waiting for a report builder update from one of our developers.

[davepusey]

Thanks.

Any idea when that might be released?

[Hemoco]

Confirmed. This will be fixed in our next update.

[davepusey]

I think i've found the problem...

Changed line 598 of asset.aspx to...

<td align="left" class="stippel"><%: ((DateTime)(Master.DsAsset.Rows[0]["LastFullimage"])).ToString(LS.User.Current().DateFormat + " HH:mm:ss") %></td>

...and now it is correct. (changes highlighted in red)

It appears that none of these custom date fields (lines 549 to 600) are using the LS.User.Current().DateFormat setting when being displayed.

Hopefully this can be fixed in an update so I don't have to keep using a modified version of the code?