FMS on DocDate

[Former Member]

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.

[former_member325312]

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

[Former Member]

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

Thanks,

Gordon