Import Subscription Expiry Date

Discussion in 'aMember Pro v.4' started by robo, Dec 8, 2011.

  1. robo

    robo New Member

    Joined:
    Nov 13, 2011
    Messages:
    22
    Hi,

    I had problems importing dates in suggested european format - dd.mm.yy didn't seem to work. I think it was still treating them as US.

    I had to change my import file to be mm/dd/yy and it worked okay.

    Cheers.
    robo, Dec 8, 2011
    #1
  2. perschulze

    perschulze New Member

    Joined:
    Jul 7, 2010
    Messages:
    2
    How did you do that?
    perschulze, Dec 9, 2011
    #2
  3. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Import function uses standard PHP functions to convert string to date.

    http://www.php.net/manual/en/datetime.formats.date.php

    If you open your CSV file in Excel, and get your dates recognized as dates, you can set cells format a date format recognized by aMember, and save CSV file back.
    alex, Dec 9, 2011
    #3

Share This Page