Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a comments column which might have dates like 'Oct-14' or '14-Oct-2016'. I would like to keep them in this format and not as a date.
For this I used Text() function, however the result is not as required. Any solution to this?
Please find the excel and QVW attached.
Regards,
Anagha
Change this variable at the start of this script..
SET DateFormat='DD:MM:YYYY';
what is the Data & what is the expected output? I am not able to open QVW as I don't have QV in my system
Hi,
I understand that, this issue is a source data format issue.
In excel 'Oct-14' is in date format and the value of the cell in excel is '1/10/2014'.
Please try to change the column property in excel as text and change the value from '1/10/2014' to 'Oct-14'.
Hope this helps.
Thanks.
Hi,
This is an excel issue, excel stores actual dates in a 5 digit numerical value, when you are converting it to text it is returning the data as "raw" data. This will only ever happen when the field only contains a date.
See attached, for the example it should work.
Change this variable at the start of this script..
SET DateFormat='DD:MM:YYYY';