topic Re: Manipulate dates to convert them into ranges in SAS Visual Analytics

Manipulate dates to convert them into ranges

GuillermoPH — Thu, 23 Feb 2017 20:55:34 GMT

Hello everyone!

This is my first day as a VA Designer and i'm having trouble with Range Sliders. I'm trying to put in it a date called 'Fecha Expedicion' but it is in DATETIME format; what i need it is to be in a YYYYMM-ish format. For example: if i have '13 de Septiembre de 2010 06:58:43' it should be '2010Sep' or 'Sep2010', the order is not important; this way i'm expecting the slider to go trough complete months and not through days.

Is there a way to do this in VA? I'm currently using the 6.3 version.

Thanks in advance!

Re: Manipulate dates to convert them into ranges

SimonJ — Fri, 24 Feb 2017 10:33:12 GMT

I only know this for 7.1it may work If you select the date field in question and duplicate this field, then format the field to a MMMYYYY format this should work

Re: Manipulate dates to convert them into ranges

GuillermoPH — Fri, 24 Feb 2017 15:24:59 GMT

I only had to change the format, it was quite easy actually. Thanks a lot!