PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Date Format in CSV export

  1. Hi Guys --

    I've got a field populating with today's date (instead of trying to strip the time from the auto-generated one) and it works fine but for one thing: It exports as yyyy-mm-dd, regardless of the format I set.

    I need to get backslashes in there.

    Any thoughts?

    -m

    Posted 12 years ago on Saturday August 25, 2012 | Permalink
  2. Note: Looking at the entries in the back end, it's coming through correctly as mm/dd/yyyy.

    Posted 12 years ago on Saturday August 25, 2012 | Permalink
  3. How are you populating the field with the current date? Can you post how you're doing that?

    I wouldn't rely too much on how the date is displayed in the entries. How is the date being stored in the database?

    Also, if you would like, you can export your form as XML (Forms > Import/Export > then the top middle menu item, Export Forms. ) Email it to chris@rocketgenius.com and I will take a look at how it's working.

    There was an old bug which did the same thing, but it was repaired a couple years ago:
    http://www.gravityhelp.com/forums/topic/notification-date-format#post-6182

    Posted 12 years ago on Sunday August 26, 2012 | Permalink
  4. Hi Chris,

    Date is being put into Date Picker, format mm/dd/yyyy -- populated with {date_mdy}. Weird thing is I thought this was working fine a couple days ago, but it certainly isn't now (no changes or updates). CSV is coming through yyyy-mm-dd.

    Form export in your inbox.

    Many thanks,

    -m

    Posted 12 years ago on Sunday August 26, 2012 | Permalink