Fiscal month from date

Help Studio
1

Hi,

Could you please let me know how to get the fiscal month from the date.

Date Format : 01.03.2022
Fiscal Month expected : 12

Thank you.

2

Hi,

Hope the following helps you.

fyStart = 4
yourString ="01.03.2022"


m = Cint(yourString.SubString(3,2))

Then

if (m<fyStart,13-fyStart+m,m-fyStart+1)

returns 12

Regards,

1 Like
3

@aishwarya1

Check below thread for your reference

Hope this will help you

Thanks

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.