Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Manipulate dates to convert them into ranges

Reply
Occasional Contributor
Posts: 8

Manipulate dates to convert them into ranges

[ Edited ]

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!

Occasional Contributor
Posts: 7

Re: Manipulate dates to convert them into ranges

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
Occasional Contributor
Posts: 8

Re: Manipulate dates to convert them into ranges

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

Post a Question
Discussion Stats
  • 2 replies
  • 98 views
  • 1 like
  • 2 in conversation