• 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 RSFiles translate date in number

How RSFiles translate date in number 11 years 3 months ago #20932

  • sandro6
  • sandro6's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
Hi.
I see dates in RSFILES are stored as number, how it do the conversion?
I need to change manually (or enter for new) the modifieddate but I do not know the number to enter for today.
Someone can help me?
The administrator has disabled public write access.

How RSFiles translate date in number 11 years 3 months ago #20934

  • sandro6
  • sandro6's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
I solved (see formula in VBA excel):

number = (Int(Now()) - 25569) * 86400 + (Hour(Time()) * 3600) + (Minute(Time())) * 60 + Second(Time())

So now I can update files with FTP and with phpmyadmin change the modifieddate with the right value! :-)
The administrator has disabled public write access.
  • 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!