Dates takes the epoch start date (1970) when we edit the project task

Whenever we inline edit the project task it is taking epoch date, also same date is refelecting in email notification as well kindly assist how to fix it.

Iā€™d like to try and reproduce this. Can you please provide more details?

  • Where youā€™re trying this, which module, which screen?
  • what you type
  • what you get in the field
  • what you think you should be getting instead
  • what is your PHP date.timezone setting?

I was playing with different values and this is what I foundā€¦

It works if you use a format like dd/mm/yyyy
It doesnā€™t work with other formats, but I get an error, not just a 1970 dateā€¦

Iā€™ve been playing around with different values.

it works with values in formats like dd/mm/yyyy

it doesnā€™t work with other formats, but I get an error and it refuses to save, it doesnā€™t just save a mysterious 1970 dateā€¦
image

That fix is for this same issue? Anyway, it first appeared in 7.14.5, but we donā€™t know which version @jyotip is runningā€¦

I am using Version 7.11.10

also same error I can see in project module aswell

Hi @pgr

  • Where youā€™re trying this, which module, which screen?
    I am trying this in project and project task module, while inline editing
  • what you type
    In inline editing I am selecting a date less than start date
  • what you get in the field
    if date is less than finish date it shows 1970 date and if it is greater than finish date it shows correct date
  • what you think you should be getting instead
    I should see what i select not 1970 date

How could be finish date less than(previous than) start date for project or project task? :thinking:

Youā€™re still not giving all the information I asked, sorryā€¦ :slight_smile:

The timezone setting is all-important in this case.

And you could try the other formats to see if it works:

mm/dd/yyyy

such as 12/31/2009

Hi @pgr

I am using this, I treid other format as well but its still showing epoch date

In Admin / Diagnostics / phpinfo

what is the date.timezone setting?

This is your definition at the PHP level; the ones you showed in the screenshot are at the SuiteCRM app level (also useful to know, thanks)

its date.timezone=UTC

You need something like this: (Replace Europe/London with your location)

date.timezone = "Europe/London"

# List of Supported Timezones

Will it not support UTC?

Where are you setting this value?

Php.ini

in php.ini

You can try to set like this:

date.timezone = ā€œUTCā€

Make sure you restart web server.


If need specific:

date.timezone = ā€œAmerica/New_Yorkā€

sure, thanks for reply