G Guest Jul 5, 2006 #1 how can i show the leading zeros in the week number format? for instance: week 1 would show 01-2006 week 9 wpid; sjpw 09-2006
how can i show the leading zeros in the week number format? for instance: week 1 would show 01-2006 week 9 wpid; sjpw 09-2006
M MGFoster Jul 5, 2006 #2 Martina said: how can i show the leading zeros in the week number format? for instance: week 1 would show 01-2006 week 9 wpid; sjpw 09-2006 Click to expand... Format(date_column,"ww-yyyy")
Martina said: how can i show the leading zeros in the week number format? for instance: week 1 would show 01-2006 week 9 wpid; sjpw 09-2006 Click to expand... Format(date_column,"ww-yyyy")
M Marshall Barton Jul 5, 2006 #3 Martina said: how can i show the leading zeros in the week number format? for instance: week 1 would show 01-2006 week 9 wpid; sjpw 09-2006 Click to expand... I don't know how you are calculating the week number, but maybe this will help: Format(DatePart("w", datefield), "00") & Format(DatePart("yyyy", datefield), "0000")
Martina said: how can i show the leading zeros in the week number format? for instance: week 1 would show 01-2006 week 9 wpid; sjpw 09-2006 Click to expand... I don't know how you are calculating the week number, but maybe this will help: Format(DatePart("w", datefield), "00") & Format(DatePart("yyyy", datefield), "0000")
G Guest Jul 5, 2006 #4 Marsh, thank you so much! Your formula helped! I just used ww insted of w and included &"-"& inbetween the date parts. Would you recommend any books on advanced access functions?
Marsh, thank you so much! Your formula helped! I just used ww insted of w and included &"-"& inbetween the date parts. Would you recommend any books on advanced access functions?
