Date Format

[Srinivas]

Hi All,

My date format is few of 'Text format'and few of 'Number format' .

Like : 2014-03-01

          2014-03-01

          2011-07-01... Etc this are text formate...

        40728

        40729

        40730

        40731

        40732... Etc this are Number format....

Could you help on this..

Advance Thanks

Munna

[#2]

Check this in a text object by selecting any one value randomly

=Date(Date#(DateField,'YYY-DD-MM'),'DD/MM/YYYY')

If it works, then use as is in the load script by changing with your DateField.

[#3]

Upadte :

Use this will work as you expected.

=alt(date#( DateField ,'YYYY/MM/DD' ),
   date(DateField,'DD/MM/YYYY'))

[MayilVahanan]

Hi

Try like this

In script,

Alt(Date(Date#(DateField,'YYYY-MM-DD'),'DD/MM/YYYY') , Date(DateField,'DD/MM/YYYY')) AS DateField

Hope that helps

[jagan]

Hi,

Try like this in load script

Data:

LOAD

*,

Alt(Date(Date#(DateDimensionName,'YYYY-MM-DD')) , Date(DateDimensionName)) AS DateField

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[er_mohit]

See the attached file

Date(num(alt(DAtefield)),'YYYY-MM-DD') as Date

[maxgro]

as already suggested use alt function when you have different format in the same field

you can find a detailed explanation at pag 8 of this doc

QlikView Date fields

[MK_QSL]

Load

DATE(Alt(Date#(DATE,'YYYY-MM-DD'),

  DATE)) as DATE Inline

[

  DATE

  2014-03-01

    2014-03-01

    2011-07-01

        40728

        40729

        40730

        40731

        40732

];