Displaying Date Field on Dashboard Issue

[#1]

Hi,

Why is my DATE field YEAR showing 1899, 1900  and so on... ??

Pls Need Help !!

[ashfaq_haseeb]

Hi,

I think you have some hijri or roman dates.

Can you post some 4 to 5 lines of data from database to look over.

Regards

ASHFAQ

[jpenuliar]

See, if you Field is formatted 'MM/DD/YYYY'

[its_anandrjs]

Hi,

Your date format is not correct let me know the snap is direct from the source or after the source or you can do set the date format according to your use or format date in proper order

SET DateFormat='MM/DD/YYYY';

Date(YourDateField,'MM/DD/YYYY') as DateField

Regards

Anand

[#5]

I did this in my script editor but still i am getting Year as 1900.

Date(Dlv.Date ,'MM/DD/YYYY') as [Delivery DATE],

Here is my source date format.