Date# Formating conversion issue?

[#1]

Im trying to format my date to look like this: ,'DD/MM/YYYY'

I thought my input mask was correct, but it won't work. Please help

=Date(Date#(ActualStart,'YYYY-MM-DD h:mm:ss TT'),'DD/MM/YYYY')

Raw Input Dates

2012-12-12T17:00:00

    2012-12-14T17:00:00

    2012-12-20T17:00:00

    2012-12-21T17:00:00

    2013-01-02T08:00:00

    2013-01-02T17:00:00

    2013-01-08T17:00:00

    2013-01-18T17:00:00

    2013-01-21T17:00:00

    2013-02-25T17:00:00

    2013-02-27T17:00:00

    2013-03-01T17:00:00

    2013-03-05T08:00:00

    2013-03-05T17:00:00

    2013-03-06T17:00:00

    2013-03-07T17:00:00

    2013-03-11T17:00:00

    2013-03-21T17:00:00

[Anonymous]

Hi,

  can you please send test application.

Regards

[#3]

This worked to resolve it on object level while the Script stripped out the 'T' so the Date function works.

Thank You Both for your expertise.

Script

Date#(Replace(ActualStart,'T',' '),'YYYY-MM-DD hh:mm:ss') as ActualStart,

Object

Date(ManualStart,'DD/MM/YYYY')

[#4]

It can be combined as one in Script, as Ralph mentioned. the 'TT' i copied from the default mask messed it up. but the key was removing the 'T' from the date. Dont know why MS project inserts in the first place.

[rbecher]

I find this T very often in XML timestamp sources. Maybe it's a standard..

- Ralf

[#6]

I am trying to get the date and time with AM PM from below ' 2010-11-02T08:42:37.6900423-07:00'

which is 2010-11-02 8:42:37 AM, can you please help

=TIMESTAMP#(Date#(Replace('2010-11-02T08:42:37.6900423-07:00','T',' '),'YYYY-MM-DDhh:mm:ss.[fff]') ,'YYYY-MM-DDhh:mm:ss TT')

[#7]

I am trying to get the date and time with AM PM from below ' 2010-11-02T08:42:37.6900423-07:00'

which is 2010-11-02 8:42:37 AM, can you please help

=TIMESTAMP#(Date#(Replace('2010-11-02T08:42:37.6900423-07:00','T',' '),'YYYY-MM-DDhh:mm:ss.[fff]') ,'YYYY-MM-DDhh:mm:ss TT')