topic Date issue !!!!!1 in QlikView

Date issue !!!!!1

Wed, 07 May 2014 05:44:07 GMT

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

Re: Date issue !!!!!1

its_anandrjs — Wed, 07 May 2014 06:05:11 GMT

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'))

Re: Date issue !!!!!1

hic — Wed, 07 May 2014 09:27:05 GMT

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