Hi

We've got our DNN server somewhere in sunny California - and we're here in foggy cold London...

We'd like to get the CREATEDDATE and UPLOADEDDATE fields (plus the Comment Date fields) displayed in the London (zero) timezone - but nothing we change in the site settings seems to change the displayed date.

Is there anything we can do in the templates XML to alter the displayed date? I think this might actually be a general issue with our DNN set up rather than a repository one - I can't seem to get a few other fields (e.g. the site log) to report settings in our timezone either - but the only user visible problem at present is the site log issue.

Any help appreciated

Thanks

Stuart

If you are part developer.... then you could try what I did eventually - which is edit the SQL Stored Procedures where the articles and comments are inserted - e.g. this is what grmAddRepositoryObject became:

ALTER PROCEDURE "dbo"."grmAddRepositoryObject"

@UserName    nvarchar(150),
@ModuleID    int,
@Name        nvarchar(50),
@Description    ntext,
@Author    nvarchar(150),
@AuthorEMail    nvarchar(150),
@FileSize    nvarchar(12),
@PreviewImage    nvarchar(150),
@Image    nvarchar(150),
@FileName    nvarchar(150),
@Approved    int,
@ShowEMail    int,
@Summary    ntext

as

insert into dbo.grmRepositoryObjects (
  CreatedByUser,
  CreatedDate,
  UpdatedByUser,
  UpdatedDate,
  ModuleID,
  [Name],
  [Description],
  Author,
  AuthorEMail,
  FileSize,
  Downloads,
  PreviewImage,
  [Image],
  [FileName],
  Clicks,
  RatingVotes,
  RatingTotal,
  RatingAverage,
  Approved,
  ShowEMail,
  Summary
)
values (
  @UserName,
  getdate() + 0.2083333,
  @UserName,
  getdate() + 0.2083333,
  @ModuleID,
  @Name,
  @Description,
  @Author,
  @AuthorEMail,
  @FileSize,
   0,
  @PreviewImage,
  @Image,
  @FileName,
  0,
  0,
  0,
  0,
  @Approved,
  @ShowEMail,
  @Summary
)

select SCOPE_IDENTITY()


Note that 0.20833333 is the +5 hour time conversion (it is 5/24)

Hope that helps!

With regards to my own post above, i.e. re date format, I was able to work out how to edit the skin template and have the date/time appear as I wanted - not that different really to normal skinning.

---

www.jpconsulting.com.au