Date Issue

[Karim_Khan]

Hi Team,

    My Date format is 17-JAN-14 i have tried to convert it into max date/Date but unable to do the same

I wanted to calculate YTD MTD and QTD so i need the variables for the same.But my date is no geting converted it is showing '-'

Please help for the same.

Regards,

KK

stalwar1‌celambarasan‌stalwar1‌sli‌bill.markham‌

[sunny_talwar]

May be this:

=Date(Date#([CREATED],'DD-MMM-YY'),'DD/MM/YYYY')

[sunny_talwar]

or

=Date(Date#(Capitalize([CREATED]),'DD-MMM-YY'),'DD/MM/YYYY')

[Karim_Khan]

no bro still showing -

[Chanty4u]

try this

in script   

=Date(Date#([CREATED],'DD-MMM-YY'),'DD/MM/YYYY') as datefield

[maxgro]

if you have JAN, you need MMM

=Date(Date#([CREATED],'DD-MMM-YY'),'DD/MM/YYYY')

[sunny_talwar · Accepted solution]

How about this?

=Date(Date#(Capitalize([CREATED]),'DD-MMM-YY'),'DD/MM/YYYY')

[Anonymous]

Hi

In the editor  Please change as below ?

SET TimeFormat='h:mm:ss TT';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oc