Feb 15 2023 10:21 PM
Hi,
i have some problems with date in a List on Sharepoint
i would like use the date to make an order number like : YYYYMMDD-XX : XX is a number from 0 to X. i would like to reset this number everyday
i have this problem:
when i have the formula : MONTH(created), i obtain "2", ok for Februar but when i write: TEXT(MONTH(created);"MM"), i obtain "1"
and a question: how can i do to reset my number everyday...
Thanks !
Bruno
Feb 19 2023 02:48 AM
SolutionHi @Bruno62,
this is complicated and will not work with a calculated formula alone. You have to create your own "Counter" Logic if you basically want to count all elements that have been created today
I would use a Power Automate flow
MONTH(created)
returns the month, so returns a 2.
TEXT(MONTH(created);"MM")
first calculates the month of the created date as a "2" and then takes that "2" and tries to formats it using the "MM" date format. This is a wierd syntax as MONTH(created) does not return a date.
Just use this formula instead to get the month part of a date with leading zeros
TEXT(created;"MM")
Best Regards,
Sven