I found the way to find the last day of previous month, but cannot get on how to convert it to the format as “dd MMM yyyy”. As I would like to make it as part of the file name e.g “Data at 31 May 2020.xlsx”
I used “Assign” with “New DateTime(now.Date.Year, now.Date.Month,1).AddDays(-1)”
and then get the output as “05/31/2020 00:00:00”
Welcome to the forum
once you have parsed a string into dateTime then we do a reformatting on string base in case of an alternate representation is needed. A reformat the internal representation of the datetime is not to do and should not be targeted
Got it. Thank you so much
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.