calculate day from date

[littleskinny83]

hi..
I want to ask how to calculate day from date. For example 21/05/08 -
21/06/08, how many days between these dates and how to calculate days
from these dates.What is the format to convert date to day and format
to culcalate this culcalation.

 

[John W. Vinson]

hi..
I want to ask how to calculate day from date. For example 21/05/08 -
21/06/08, how many days between these dates and how to calculate days
from these dates.What is the format to convert date to day and format
to culcalate this culcalation.

Day([datefield])

will give an integer 21 if datefield contains #2008-05-21#.

DateDiff("d", [onedate], [anotherdate])

will give the integer number of midnights between the two date values.

 

[Tom Lake]

hi..
I want to ask how to calculate day from date. For example 21/05/08 -
21/06/08, how many days between these dates and how to calculate days
from these dates.What is the format to convert date to day and format
to culcalate this culcalation.

format(#21/05/2008#,"dddd")

will give you the day of the week, Monday

Tom Lake

 

[littleskinny83]

hi..
I want to ask how to calculate day from date. For example 21/05/08 -
21/06/08, how many days between these dates and how to calculate days
from these dates.What is the format to convert date to day and format
to culcalate this culcalation.

Day([datefield])

will give an integer 21 if datefield contains #2008-05-21#.

DateDiff("d", [onedate], [anotherdate])

will give the integer number of midnights between the two date values.

It works..Thank you.