how to convert actual date format

[madhubabum]

Hi all

  How to convert 42185 to actual date format

[jsingh71]

Date(<Date_Field>,'MM/DD/YYYY')

During Load

Date(<Date_Field>,'MM/DD/YYYY') as <NewFieldName>

As per your Example:

=Date('42185', 'MM/DD/YYYY')

Output:  06/30/2015

[alexandros17]

Date(42185)

let me know

[arulsettu]

try this

=Date('42185')

[krishna20]

Hi,

If you wanna see simple date format of your date field. Take that field in the list box.Go to properties->

Number->override Document Settings-> select Date/.

[Gabriel]

Hi,

If you wanted to convert it Numeric value from the script to date or in UI do DATE(42185).

This should give you date format according to how you've define your date format from the GLOBAL variable in the script

[vardhancse]

Date(Floor(42185))

o/p: 30/06/2015

[#8]

[sunilkumarqv]

try like this

Date(Date#(DateField,'MM/DD/YYYY'))

[SatyaPaleti]

Hi Sunil,

Date(Floor(42185)) as Date

Thank you,

SatyaPaleti