Reporting date

[ldiaz (Leonardo Diaz)]

hi. how can i set my reporting date in this format

JANUARY 2020
FEBUARY 2020
MARCH 2020
APRIL 2020
MAY 2020
JUNE 2020

[fernando_zuluaga]

Hey

can you try the following code?

Now.ToString("MMMM yyyy")

[ldiaz (Leonardo Diaz)]

io_Config(“Filename HGCE”).ToString.Replace(“<%ReportingDate2%>”,DateTime.ParseExact(ReportingDate2, “MMMM yyyy”, System.Globalization.CultureInfo.InvariantCulture).Tostring(“MMMM yyyy”))

just want to ask if this is right.

[fernando_zuluaga]

Hey

thats correct, if any issue ill be happy to help just check if your ReportinDate2 variable is in the format MMMM yyyy, if not please change that input format

Regards

[ldiaz (Leonardo Diaz)]

how about doing the MMMM all uppercase?

[fernando_zuluaga]

io_Config(“Filename HGCE”).ToString.Replace(“<%ReportingDate2%>”,DateTime.ParseExact(ReportingDate2, “MMMM yyyy”, System.Globalization.CultureInfo.InvariantCulture).Tostring(“MMMM yyyy”)).ToUpper()