Find last day of the previous quarter

[BosKev]

Hi All,

Below gives me the 1st day of the current quarter I just want to subtract by 1 day to get to previous quarter or if there is a better way to write this.

Left(DateTimeToday(),5)+
PadLeft(ToString(3*Floor((DateTimeMonth(DateTimeToday())-1)/3)+1,0),2,"0")+"-"
+ "01"

Thanks,

BosKev

[jdunkerley79 · Accepted solution]

I would do:

DateTimeAdd(
    Left(DateTimeToday(),5)+
    PadLeft(ToString(3*Floor((DateTimeMonth(DateTimeToday())-1)/3)+1,0),2,"0")+
    "-01",-1,"days")

[BosKev]

Thanks, wasn't completely sure all the components in the functions as i got it from another discussion, will look it up later.

[Anjali03]

Hi,

Could you please share the expression to find first day of previous Quarter.