JonRowland
Active Member
- Joined
- May 9, 2003
- Messages
- 417
- Office Version
- 365
- Platform
- Windows
Hi,
I have a query regarding DartPart and the format of the value it returns.
My example is using date 01/01/2018
If I use DatePart("d", #01/01/2018#) the value is returned is 1. However, what I would like is to have the value, if less than ten, to have a proceeding zero, eg 01.
How would I go about this?
Jon
I have a query regarding DartPart and the format of the value it returns.
My example is using date 01/01/2018
If I use DatePart("d", #01/01/2018#) the value is returned is 1. However, what I would like is to have the value, if less than ten, to have a proceeding zero, eg 01.
How would I go about this?
Jon