Hi SAS VA community!
I'm dealing with a situation that is driving me nuts: when I choose to export data from a VA report to Excel, it messes up with date formats.
For example, I have this graph I need to export in order to work with the data, it has a date variable named FECTERMINADO which in EG I set its format as datetime27.6; in VA it is formatted as MMMYYYY. When I export it to Excel I get a bunch of ##'s. I've tried everything but I keep failing on keeping the format... 😞
![columnas.png columnas.png](https://communities.sas.com/t5/image/serverpage/image-id/21272i7323569222A56DF7/image-size/large?v=v2&px=999)
![sample.png sample.png](https://communities.sas.com/t5/image/serverpage/image-id/21271i90361D781D2F2C7F/image-size/large?v=1.0&px=-1)
Please, any help will be much appreciated!
Thanks in advance, regards;