in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.
InaPlex Forums » Product Forums » Inaport » Date format question

Date format question

Last post 01-31-2009 8:42 by admin. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 01-31-2009 3:08

    Date format question

    Reply Contact
    I'm importing from DBF to GMPE 8.0 and have added a new field UpdatedDate to hold the current time. I created it as:    d2s(now(),"M/d/yyyy h:mm a z")However, when I test the expression, the result is:   1/30/2009 6:03 a -8

    How may I get the AM/PM and time zone to display? Many thanks for your help.

     

    Sue Burke/IT
    The JESUS Film Project
    www.JesusFilm.org
    Filed under:

  • 01-31-2009 8:42 In reply to

    Re: Date format question

    Reply Contact

    Hi Sue

    Looks like you have found an incompatibility between the formatting characters used in the old style date format function (dtos()) and the new (d2s()).

    Doing this:    d2s(now(), "M/d/yyyy h:mm tt zzz")

    produces:     1/30/2009 11:37 PM -08:00

    The new AM/PM designator is "t", or "tt" for long form.

    The time zone designator is "z" or "zz": the result is always the hour offset from GMT, not a code like "PST".

    The new characters are all documented in the help, but the "a" is incorrectly shown in the expression editor.

    HTH

    Regards

    Admin
    Filed under:
Page 1 of 1 (2 items)
InaPlex Limited 2011