• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: How to store {global:date_added} in the database?

How to store {global:date_added} in the database? 11 years 2 months ago #26564

RSForm stores the date and the time in {global:date_added}. It is well displayed as dd-mm-YYYY hh:mm:ss in the Manage Submissions section, Date Submitted field. However, it cannot be stored in any tables of the database in any datetime fields (which have the format YYYY-mm-dd hh:mm:ss).

How to convert the {global:date_added} format to enable its storage in a datetime field of a database table?

Many thanks & kind regards

Dominique
The administrator has disabled public write access.

How to store {global:date_added} in the database? 11 years 2 months ago #26575

  • adrianp
  • adrianp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 631
  • Thank you received: 146
Hello,

The global placeholder you have mentioned is used to return the date and time when the form was submitted from the database and does not actually store it(within the RSForm!Pro database tables, the submitted date is actually saved in the proper format, found in the "#__rsform_submissions" table).

The date/time returned by {global:date_added} placeholder will also be according to the "Date Mask" you have specified via RSForm!Pro Configuration area(backend > Components > RSForm!Pro > Configuration > Settings). In your case, you will have to change the Date Mask into:

Y-m-d H:i:s

This may return for example: 2014-02-19 08:16:02

More information on RSForm!Pro Configuration area can be found here:

www.rsjoomla.com/support/documentation/v...9-configuration.html
This is not official customer support. To receive your support, submit a support ticket here.
Last Edit: 11 years 2 months ago by adrianp.
The administrator has disabled public write access.
The following user(s) said Thank You: patrick.jackson, d.chesnais
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!