on 09-30-2016 7:02 PM
Hi,
PI delivered an Output file which has Date as 2016/04/05. When the vendor open the file in text pad its showing as 2016/04/05, but when they try to open it through excel its not holding the zero i., 2016/4/5. is there any setting we can make in PI to hold the zeros. The file name is saved as .csv in receiver sftp channel.
Thanks,
Vijay.
Vijay,
When the vendor open the file in text pad its showing as 2016/04/05 you already have your answer here , So the date format sent by PI is as expected its the excel which formats date in such a way try in google to change the date format in excel I dont think PI system can do anything here.
Br,
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.