1 Reply Latest reply: May 15, 2014 10:15 AM by Olly Bond RSS

    Date Format Issue

    outdoorsguy19 _

      I'm trying to export a pdf with the dates listed as "06FEB13"

       

      I can get the field to populate if it's character based, but I get a null when I try to export it as a short date.  Any suggestions in getting it to export as a date?

       

      Thank you!

        • Date Format Issue
          Olly Bond

          Hello Outdoorsguy and welcome,

           

          Monarch can read dates in many formats - including ddMMMyy like yours - but it writes dates in the format defined by your Windows Control Panel. You can tweak this in the Regional Settings dialog. I don't think there's a way to export the date as 06FEB13 and make it a date field without changing the way Windows shows all your dates.

           

          Hope this helps,

           

          Olly