Fetching month from date?

[Navya08]

How to fetch  only month from the date?

03/01/2024

[alexnajm]

We'll need more info to be safe... for example,

• How do you want the month? Full month name, short month name, or digits? Digits is below
• What order is the date? MM/DD/YYYY or DD/MM/YYYY?

This will work based on my assumptions - you can change around with the date time functions as needed:

DateTimeFormat(DateTimeParse("03/01/2024","%m/%d/%Y"),"%m")

DateTime Functions (alteryx.com)

[aatalai]

If is already in date format then this would work too 

DateTimeMonth([field])

if not then  DateTimeMonth( DateTimeParse([field],"%m/%d/%Y"))

[Navya08]

My date format is

yyyy-mm-dd

and i need full month in one column and just an

year in second column

actually then i have to compare that between these months no transaction should be done for that what will be the formula to compare months?

like example:

Sheet 1 :  01-08-2024.    Month- jan

Sheet 1 :   11-23-2023.    Month- nov

sheet2 : 02-01-2024. Month: feb

payment: 500euros

so i want to have a formula in place to show that during or after  nov 2023 to jan 2024 they should not be any payment 

but as we see in sheet 2 we have one payment as on month feb 2024

[Navya08]

@aatalai @alexnajm  Can you help with above

[aatalai]

I'd do that slight differently then from sheet 1 I would find the min and max using summarise and then append it to sheet 2 data  and compare it with a formaul tool or filter

see worfklow atttached (done with fliter)

@Navya08 let me know if this does the trick