topic Re: How to convert date from this format 25/09/2019 to 01/09/2019 in SAS Visual Analytics

How to convert date from this format 25/09/2019 to 01/09/2019

Lena2017 — Thu, 17 Oct 2019 13:39:06 GMT

Hi ,

I was wondering if there a way to convert a date from 25/09/2019 to 01/09/2019 in SAS Viya without writing an actual code?

Thanks!

Re: How to convert date from this format 25/09/2019 to 01/09/2019

Patrick — Fri, 18 Oct 2019 02:18:51 GMT

This is more than just displaying a value differently. You seem to want to align datetime values to the beginning of the month.

You could either use a format that only returns the month & year (with VA joining/aggregating using the formatted values) or you could create a calculated column and there use a function like intnx().

...and please take whatever I write about Viya with a grain of salt. I'm still getting up-to-speed with it.

Re: How to convert date from this format 25/09/2019 to 01/09/2019

FredrikE — Fri, 18 Oct 2019 10:16:26 GMT

Hi!

If I understand you correct you want to get the first day of the month for a date, if so you can use the following formula:

DateFromMDY(Month('Date'n), 1, Year('Date'n))

Change 'Date'n to your date variable.

You can also click the formula using the formula editor.

You do this by creating a new calculated item 🙂

//Fredrik

Re: How to convert date from this format 25/09/2019 to 01/09/2019

Lena2017 — Sat, 19 Oct 2019 00:37:22 GMT

Wow! It works! thank you so much!