how to get last second date of previous quarter using today

[stonecold111]

i mean i want 3/30/2017

By using this i am getting 3/31/2017 but iwant 3/30/2017

=QuarterEnd(today(),-1)

suggest me

[Anonymous]

Date(QuarterEnd(today(),-1)-1,'MM/DD/YYYY')??

[stonecold111]

and how to get 3/30/2017 21:00:00

[Anonymous]

If 21:00:00 is fixed just add it using '&'??

[qlikview979]

Hi

if that is fixed just do this

=Date(QuarterEnd(Today(),-1)-1,'MM/DD/YYYY')&'21:00:00'

[stonecold111 · Accepted solution]

date(DayStart(QuarterEnd(today(),-1),-1)+(22/24),'YYYY/MM/DD hh:mm:ss')

what about this .. i got it

[tresesco]

I read your requirement

suresh kumar wrote:

and how to get 3/30/2017 21:00:00

and you got that using

date(DayStart(QuarterEnd(today(),-1),-1)+(22/24),'YYYY/MM/DD hh:mm:ss')

should not this be 21/24  ?

[stonecold111]

yes ...