Hi,
I have tab where i have got start and nd dates. dat are i format dd/mm/yyyy. it was pikin them up i the right format but now fr the end date it gives 00/01/1900.
e.g
start date end date
01/01/216 1/06/2017
In pivot, I a getng 01/01/2016 as start date which is fine but end date is coming out as 00/1/1900. what i gettin wrong here?
I hv checked the format and its all fine so wud be great if someon ou help me here
thanks fr your help in advance
regards,
FH
I have tab where i have got start and nd dates. dat are i format dd/mm/yyyy. it was pikin them up i the right format but now fr the end date it gives 00/01/1900.
e.g
start date end date
01/01/216 1/06/2017
In pivot, I a getng 01/01/2016 as start date which is fine but end date is coming out as 00/1/1900. what i gettin wrong here?
I hv checked the format and its all fine so wud be great if someon ou help me here
thanks fr your help in advance
regards,
FH