Date format

[#1]

Hi Every one,

I have issue with date format.

In list box I have to show date but it showing like - 201412, when I make it to date(reporting-date) then its looks like - 6/11/2451 show how to change it to normal.

Thank you

[robert_mika]

Here is post with similar issue and how to solve it

date format

Look at my last response and use these expression:

[avinashelite]

Hi Raj,

In which format the date is saved??

try with date or date# function this should do. If your still facing any issues please provide the sample data so that we can work on that.

[maleksafa]

first option is to change the date format in the load script, in the first page

SET DateFormat='DD/MM/YYYY';

or when loading the date field you can change the format uising the Date() function date(expression [ , format-code ])

[luciancotea]

You have the date loaded as integer (201412). You need to load it (in the script) as date. Depending on the way you have you data stored, use date#() or makedate() functions to transform string or integer into date.

Note: date() is a formatting function, not a transformation one.

[#6]

Date is stored in 201412, so how can I change it to 31/12/2014.

[jagan · Accepted solution]

Hi,

Try like this

MonthEnd(Date#('201412', 'YYYYMM'))

OR

MonthEnd(Date#(DateFieldName, 'YYYYMM'))

Hope this helps you.

Regards,

Jagan.