Issue with Text() conversion

[anagharao]

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

[Kushal_Chawda]

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

[arasantorule]

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.

[pho3nix90]

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.

[MK_QSL · Accepted solution]

Change this variable at the start of this script..

SET DateFormat='DD:MM:YYYY';