Need help on Date function

System date minus previous date if any need to get the results like this please provide the syntax

example :10/29/2022 - 11/23/2022 = 11
need to generate and compare billing cycle like from 1 to 31, without writing and using excel file, is it possible

Pls help if anyone

Hi @vzvenkat ,

We would need more details of what you are trying to perform.

The example provided isn’t quite clear as to how you get the value 11. If you could let us know the logic/calculation used we would be able to derive the same for the solution.

Also would need more clarity on Generating and Comparing Billing Cycle.