date Format

[#1]

Hi,

I have a field(RDATE) in the following format

Apr  1 2013  1:00AM

Apr  1 2013 12:00AM

Apr  2 2013  1:00AM

Apr  2 2013 12:00AM

Apr  3 2013  1:00AM

Apr  3 2013 12:00AM

Apr  4 2013  1:00AM

Apr  4 2013 12:00AM

Apr  5 2013  1:00AM

Apr  5 2013  3:34PM

Apr  5 2013  4:34PM

Apr  5 2013 12:00AM

Apr  6 2013  1:00AM

Apr  6 2013 12:00AM

Apr  8 2013  1:00AM

Apr  8 2013 12:00AM

And I' am required to convert the above date format into DD/MM/YYYY. After converting the above I need to make use of the above field in a calendar object, I' am stuck somwhere and not getting the required results.

Kindly help

[Clever_Anjos]

date(floor(RDATE),'DD/MM/YYY')

[Anonymous · Accepted solution]

Hi Gaurav.

Try Using:

Date( Date#('Apr  1 2013  1:00AM', 'MMM  D YYYY  hh:mmTT') )

For testing....

And than replace the String for your date column

[#4]

Hi Anjos,

The Solution suggested by you is not working and it's showing blank field. Any other way of achieving it

[v_iyyappan]

Hi,

Try like this

Date(TimeStamp#(RDATE, 'MMM D YYYY hh:mm TT'),'DD/MM/YYYY' )

Regards,

[Anonymous]

Gaurav, here is na attached example, using

Date( Date#(RDATE, 'MMM  D YYYY  hh:mmTT') )

[Clever_Anjos]

Your RDATE is a date or string field?

date(floor(date#(RDATE, 'MMM  D YYYY  hh:mmTT')),'DD/MM/YYYY')

[felipe_dutra]

Hi!

Try this:

MapMonth:

Mapping

LOAD * Inline

[

x, y

Jan, 1

Feb, 2

Mar, 3

Apr, 4

May, 5

Jun, 6

Jul, 7

Aug, 8

Sep, 9

Oct, 10

Nov, 11

Dec, 12

];

Tab:

LOAD

  Date(SubField(Replace(RDATE, '  ', ' '), ' ', 2)&'/'&

  ApplyMap('MapMonth', SubField(Replace(RDATE, '  ', ' '), ' ', 1), Null())&'/'&

  SubField(Replace(RDATE, '  ', ' '), ' ', 3), 'DD/MM/YYYY') as RDATE

FROM

...

[#9]

Many thanks Lucas for your help

[Clever_Anjos]

If you want only dates, remenber to use "floor"