Desktop productivity for business analysts and programmers

Change date from 'DD/MM/YYYY' to 'YYYYMM'

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

Change date from 'DD/MM/YYYY' to 'YYYYMM'

Hi,

I'm using theQuery builder in SAS Enterprise Guide 4.3 & have a date field in my data in the 'DDMONYYYY' format which I want to change to 'MONYY' format.

When I use the Query builder & change the format to 'DTMONYY.w', the results for all rows is 'JAN60'?

Can anyone advise what's happening here?

Thanks 


Accepted Solutions
Solution
‎12-15-2013 05:36 PM
Respected Advisor
Posts: 3,776

Re: Change date from 'DD/MM/YYYY' to 'YYYYMM'

DTMONYY is for datetime variable you want MONYY for your date(no time) variable.

View solution in original post


All Replies
Solution
‎12-15-2013 05:36 PM
Respected Advisor
Posts: 3,776

Re: Change date from 'DD/MM/YYYY' to 'YYYYMM'

DTMONYY is for datetime variable you want MONYY for your date(no time) variable.

Frequent Contributor
Posts: 80

Re: Change date from 'DD/MM/YYYY' to 'YYYYMM'

Thanks data_null_; & Arthur,

For some reason I didn't notice the option to select 'Date' instead of 'Date Time' ...

Cheers Smiley Happy

Esteemed Advisor
Posts: 7,302

Re: Change date from 'DD/MM/YYYY' to 'YYYYMM'

Why not select monyy7.  ?  The format you selected expects a datetime field.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 979 views
  • 3 likes
  • 3 in conversation