Time Stamp column it is capturing UTC time

Thanks to an email of a visforms user I just realized, that the column "Date" in Visforms data view and the "Registered at" text in result an user email use php date function and not Joomla! framework functions.

As a result they seem to always use UTC time even when the local is set differently.

At the moment you have to change a bit of code to fix it.

go to components/com_visforms/models/visforms.php and find

at about line 600

Replace it with
You have of course to replace "Asia/Kolkata" with name of your timezone.

Aicha

Hello Aicha

Thank you very much, I would like to share with you that I surprised when I got the reply to my query, I cant't believed I will get the solution.

I followed your instructions and got the solution, now it is capturing exact time (Asia/Kolkata)

Thanks a lot. However I would like to show this TimeDate column in Display Data Page. Will you please send the solution for this?

Awaiting your response.

With thanks
Parashuram Singade

Hi parashuram,

this is much more complex, because showing the date in frontend data view is not yet a feature in visforms. For visforms works multi language and with many features even in the data view, making a complete instruction for you is just as much work as to implement the feature itself. Therefore I can only give you a guide which you might be able to follow if you have some knowledge of HTML. But you have to implement and test for yourself.

The file you are looking for is
components/com_visforms/visformsdata/tmpl/data.php

Make a copy of it first as backup.

This file build the HTML of the data view.
There is a HTML table element with th elements. The existing th elements contain some php code (multi language text, sort function...) but basically you just have add a new th-Element inside the tr-element in the table header, with the text you want as table header. (i.e. Date). Make it the last th element just before the closing tr element.

Next you have to add the date itself in the table body.
Find the closing table element. Find the closing tr element which is some lines above the closing table element. Add a new td element immediately before that closing tr element. (After "<?php } ?>")
As content in that td element use the following code
I hope you can make it work.

Kind Regards,
Aicha

Hello Aicha

I configured it and I got what I want. Thanks a lot for your grate support.

Parashuram

Hi Parashuram,

you're wellcome!

Regards,
Aicha