Date format

[Chi]

Hi

Would you show me how I can convert 32 days to month and days?

Ex: 32 days will be one month and 2 days.

Thanks
Chi

 

[KARL DEWEY]

All months do not have 30 days but try this --
Months_Days: ([YourField] \30) & "Months and " & ([YourField] Mod 30)

 

[fredg]

Hi

Would you show me how I can convert 32 days to month and days?

Ex: 32 days will be one month and 2 days.

Thanks
Chi

What will you do when your month is February or months that have 31
days, as well as during Leap Year?

For an accurate Month and Days calculation see:

http://www.accessmvp.com/djsteele/Diff2Dates.html

 

[KARL DEWEY]

That would be --
Months_Days: ([YourField] \30) & "Months and " & ([YourField] Mod 30) & "
Days"

All months do not have 30 days but try this --
Months_Days: ([YourField] \30) & "Months and " & ([YourField] Mod 30)

Hi

Would you show me how I can convert 32 days to month and days?

Ex: 32 days will be one month and 2 days.

Thanks
Chi