formate date

  • Resolved zzaz

    (@zzaz)


    6 years, 10 months ago

    when import export
    ihave date in format datetime 1516643196
    hove converse this date
    2012-04-17 11:50:47
    2012-05-04 23:05:47
    2011-04-12 15:45:50
    2012-05-12 10:30:21
    2011-10-25 16:00:57
    to need format

    need for import date from other site

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Marcel Pol

    (@mpol)

    Did you try the importer yet? It does try to guess the date based on what you put in. If it gives a date of 1 january 1970 or the current date, it could not guess it.

    You can generate a timestamp on this website:
    https://www.timestampgenerator.com/

    Thread Starter zzaz

    (@zzaz)

    format in calc for change date
    k2=2012-04-17 11:50:47
    new =(K2-25569)*86400= 1334663447

    it work

    • This reply was modified 6 years, 10 months ago by zzaz.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘formate date’ is closed to new replies.