Date Time Parse

Question

Hello!

I am attempting to save a file in a different folder each month for a monthly audit that we perform.

I am using the following function to attempt to get "03 March" to be the end result, and I am in need of help to parse out the date to make that happen.

DateTimeAdd(DateTimeParse(dt,f)DateTimeLastOfMonth(),-1,"months")

The bolded portion is the part I am confused on.

So before I add the DateTimeParse function, I get 2018-03-30 23:59:59 as the output. I'd like it to output as "03 March", or Month Number then Month Name, all using the DateTimeAdd function so that I do not need to update the formulas each month.

Is this the right way to approach this, or is there a better way?

Many thanks.

Thanks so much!

patrick_digan · Accepted Answer

@kevin-lindorfer I think you would want DateTimeFormat() instead. Something like this:

DateTimeFormat(DateTimeAdd(DateTimeLastOfMonth(),-1,"months"),"%m %B")

PS I can't keep DTFormat and DTParse straight either...

Kenda · Accepted Answer

Hey @kevin-lindorfer!

Try adjusting your formula to look like the following:

datetimeformat(DateTimeAdd(DateTimeLastOfMonth(),-1,"months"),"%m %B")

I changed the DateTimeParse to DateTimeFormat and moved it to the beginning.

Hope this helps!