Macro to converting Datetime into text

[rsummerhayes]

Hello 

I am trying to set up macros to deal changing a datetime to different character variables 

%let start_date = "01Jul2018:00:00:00"DT;

I want to convert the above datetime in to the equivalent two text variables below as a macro to avoid excessive data entry

**convert start_date to text format ddmmyyyy ****;

%let start_date_text =01072018;

**convert start_date to text format for financial year **;

%let fin_yr=1819;

Many Thanks!

[sustagens · Accepted solution]

Assuming the fin yr is just the current year plus 1:

%let start_date = "01Jul2018:00:00:00"DT;

%let start_date_text = %sysfunc(datepart(&start_date),ddmmyyn8.);
%put &=start_date_text;

%let fin_yr=%sysfunc(datepart(&start_date),year2.)%eval(%sysfunc(datepart(&start_date),year2.) + 1);
%put &=fin_yr;