DATE FORMAT?

[Anonymous]

HI,

i have date like this

1/2/1015_02_04

i want get like 01/02/2015  i dont want get any other thing here?

[arulsettu]

hi try like this

Date(Date#('1/2/1015_02_04','DD/MM/YYYY_HH_MM'),'DD/MM/YYYY')

[jagan]

Hi,

Try like this

Date(Date#('1/2/2015_02_04', 'M/D/YYYY_hh_mm', 'MM/DD/YYYY')

OR

Date(Date#('1/2/2015_02_04', 'D/M/YYYY_hh_mm', 'DD/MM/YYYY')

Hope it helps you.

Regards,

Jagan.

[prma7799]

Try below

=Date(Date#('1/2/2015_02_04', 'D/M/YYYY_hh_mm'), 'DD/MM/YYYY')

Thanks

PM

[mukesh24]

hi,

Try as

Date(Date#('1/2/2015_02_04', 'D/M/YYYY_hh_mm'))

[puttemans]

Hello,

This document from HIC may help you.

[tyagishaila]

Try it,

Date(date, 'DD/MM/YYYY') as date,

here date is your attribute name

[#8]

Hi Jagan,

Here I have dates like this below,all are having format is DD/MM/YYYY

but here i have a issue is 02/03/2015 and 2/3/2015 is giving as two values in list box.

i need all the below values into any of the one format.

02/03/2015

2/3/2015

1/03/2015

05/03/2015

6/3/2015

7/03/2015

i want it like

02/03/2015

02/03/2015

01/03/2015

05/03/2015

06/03/2015

07/03/2015

Plz help me i tried but i didn't get any solution for this.

[jagan]

Hi,

Can you attach some sample data?

REgards,

Jagan.

[senpradip007]

Try to use this....

date(SubField('1/2/1015_02_04', '_'), 'DD/MM/YYYY')