Date Format

[qlikview979]

Hi Experts,

I have Two Columns like StartDate, EndDate in this fields date format like this

StartDate     EndDate

1/1/2016,     12/1/2016

how can i Identify which one is "Date and which one is Month".

Regards,

Mahesh.

[avinashelite]

As per the sample data the date format is MM-DD-YYYY

try the month () and day() function you will get the right output

[Kushal_Chawda]

Do the right click on cell value instead of column header

[qlikview979]

Hi Kushal,

I Want to Identify  the format in Qlikview only.

imaging if i take in inline how can i identify in that format.

Regards,

Mahesh.

[PrashantSangle]

Still showing same....

What value you get after loading it in qlikview???

Regards

[PrashantSangle · Accepted solution]

Hi,

In that case qlikview assign format as per you define in

SET DateFormat

variable.

Regards

[qlikview979]

Hi All,

I Think, Qlikview will take Standard Format like Variable

SET DateFormat='M/D/YYYY';

Regards,

Mahesh.

[PrashantSangle]

Yes.

Regards

[qlikview979]

Hi,

Thanks to all for your Support.

Regards,

Mahesh.

[qlikview979]

Hi,

Thanks Avinash.

Regards,

Mahesh