Jun 13, 2003 #1 woolade Technical User Joined Nov 8, 2001 Messages 51 Location AU Is there a formula to use that allows you to calculate the difference in minutes between the time in a Date Time field and midnight of that same date? Thanks woolade
Is there a formula to use that allows you to calculate the difference in minutes between the time in a Date Time field and midnight of that same date? Thanks woolade
Jun 13, 2003 #2 synapsevampire Programmer Joined Mar 23, 2002 Messages 20,180 Location US Try: datediff("n", cdatetime(year({table.datefield}),month({table.datefield}),day({table.datefield}),0,0,0),{table.datefield}) Note that midnight of the same day is 12:00AM, which means that it's earlier. -k Upvote 0 Downvote
Try: datediff("n", cdatetime(year({table.datefield}),month({table.datefield}),day({table.datefield}),0,0,0),{table.datefield}) Note that midnight of the same day is 12:00AM, which means that it's earlier. -k