This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Slice based on date range

Posted on 04-17-2024 11:12 PM
Paulo
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

Hello all!
I have a table with a Date/Time collumn [Date] and I'm trying to create a slice to show only the rows from the previous month. For example, when viewing the app in April (from April 1 to April 30) the slice will show only the rows with[Date] values between March 1 and March 31 of the current year.

Could anyone point me in the righr direction to create this slice, please?

Solved Solved
0 7 500
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
lynchk21
Silver 5
Silver 5
In response to Paulo
Reply posted on --/--/---- --:-- AM

IF(

MONTH(TODAY())=1,

AND(12=(MONTH([Date])),Year(TODAY())-1=YEAR([Date])),

AND((MONTH(TODAY()))-1=(MONTH([Date])),Year(TODAY())=YEAR([Date]))

)

 

View solution in original post

Jump to Solution
7 REPLIES 7
Top Labels in this Space