Date Format

[gireesh1216]

Hi Team,

I have Start Date field like below:

Start Date
12-JAN-16
01-FEB-88
06-MAR-98
03-APR-17
02-FEB-01

I am converting Start Date to Date(Start Date,'DD/MM/YYYY').

After converting Start Date i am getting below wrong values:

Start Dtae
12-01-2016
01-02-2088
06-03-2098
03-04-2017
02-02-0001

I want start date like below:

12-01-2016

01-02-1988

06-03-1998

03-04-2017

02-02-2001

Thanks

Gireesh

[jonathandienst · Accepted solution]

Use Date(Date#([Start Date], 'DD-MMM-YY'), 'DD/MM/YYYY')

This returns the correct year for me.

[gireesh1216]

Hi Jonathan,

Above expression not working

[Sergey_Shuklin]

Hi, Gireesh!

If you use it within the script - check your date format on the top of the script. May be date format from there have a conflict with your expression (it's have a little chance to be true, but still).

[ahaahaaha]

Hi,

May be like this

Date(Date#([Start Date], 'DD-MMM-YY'), 'DD-MM-YYYY')

Andrey

[amit_saini]

Hi,

See the attachment!

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

Thanks,

AS

[gireesh1216]

SORRY Jonathan,

It's working fine.

[jonathandienst]

No problem. Glad to be able to help.