How to change date to MonthStart?

[#1]

Hello,

The following is what we're using to create our date fields. How would I manipulate this to be the month start date?

Month(MakeDate(left(right('$(vVulnerabilityFile)',11),4),left(right('$(vVulnerabilityFile)',6),2))) AS MNTH,

Thanks!

[sunny_talwar]

May be this

Date(MakeDate(left(right('$(vVulnerabilityFile)',11),4),left(right('$(vVulnerabilityFile)',6),2))) as MonthStart

[Anil_Babu_Samineni]

What does this vVulnerabilityFile? And if Date would you create few dates so then we came to know. Seems complex we can achieve by default functions may be

[vishsaggi]

What is the value you hold in vVunerabilityFile variable like i mean what is the date format that this variable holds.

You can use MonthStart(vVunerabilityFile) may be?

[#5]

this worked, thank you. I'm trying to limit a pie chart to only display one month worth of data. this is what i'm using as my expression but it's saying no data to display:

Sum({<MonthStart={$(=Max(Month))}>}CRITICAL)

Sum({<MonthStart={$(=Max(Month))}>}HIGH)

any ideas?

[sunny_talwar]

Add double or single quotes around...

Sum({<MonthStart={"$(=Max(Month))"}>}CRITICAL)

Sum({<MonthStart={"$(=Max(Month))"}>}HIGH)

[#7]

didn't work

[sunny_talwar]

My bad, you need to do Max(MonthStart)

Sum({<MonthStart={"$(=Max(MonthStart))"}>}CRITICAL)

Sum({<MonthStart={"$(=Max(MonthStart))"}>}HIGH)

[vishsaggi]

Sunny, i believe Ann is comparing Date with Month here right? I mean

MonthStart = Max(Month) ?

[#10]

It's still not working