Date issue !!!!!1

[#1]

Hi all,

I have date column with the format of MM-DD-YYYY hh:mm:ss tt' and i done differentiate both date and time stamp 

But some fields am not getting like 08/06/2013 so on

in main date source itself some fields don't have  time stamp

can u suggest me how to retrieve those fields in to date object

Please have look on attach file

Thanks

[its_anandrjs]

Update check now i make changes

Use Alt to convert multiple date formats

=Alt( Date(Timestamp#(STARTDATETIME,'MM/DD/YYYY hh:mm:ss TT'),'DD/MM/YYYY'),Date(Date#(STARTDATETIME,'MM/DD/YYYY'),'DD/MM/YYYY'))

[hic]

You use the following as format code in your script:

     TimeStamp#(STARTDATETIME,'dd/mm/yyyy hh:mm:ss tt')

BUT - format codes are case sensitive, so you cannot use 'm' to denote months. This is the reason why you have dates like '07/59/2013' ind Date2. Use 'M' instead.

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/18/number-format-codes

HIC