Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
can you please send test application.
Regards
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')
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.
I find this T very often in XML timestamp sources. Maybe it's a standard..
- Ralf
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')
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')