Skip to Content
avatar image
Former Member

FMS on DocDate

i am trying to get date by using FMS in deposit

SELECT $[$39.1.1.1.DATE]

i am using the aboe query it works but the result comes on 20100119 but i want this on 19-01-2010 .

need solution on this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 17, 2010 at 02:32 PM

    The date format you got is B1 default format. You may use cast and substring function to get what you want.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 21, 2010 at 09:36 AM

    Hi Kumar Amith

    check out this query for ur FMS

    select Convert (varchar(11),convert(DateTime,T0.[DeposDate]),105)from ODPS T0

    I think this will solve ur prob if so pls do close the thread

    cheers

    Jenny

    Add comment
    10|10000 characters needed characters exceeded