Number and date concatenation giving issue while saving data in.csv
I am facing a problem while saving data into .csv format. I am concatenating policy number and date field and want to be get saved same field in a text format. I have converted date into text and concatenated same with policy number and saving out put into .csv.
But when i am opening the file the same field is getting converted into numeric and last digit of date is also wrongly converted into 0 rather then 6.