Finding out the day of the week from a date

Belfordarren

Hi,

Im trying to find a way of finding out the day from a date given

For example

28/10/08 = Tuesday

Cheers \:D/

DenSter

Use the Date virtual table

MyDate.SETRANGE("Period Type",MyDate."Period Type"::Date);
MyDate.SETRANGE("Period Start",TODAY);
MyDate.FINDFIRST;
MESSAGE('Today is a ' + MyDate."Period Name");

MBerger

or even simpler : Have a look at the date2DWY function ( NOT the Date2DMY one ! )

Belfordarren

Cheers!!

DATE2DWY works fine!

Thanks for your help!

Darren

DenSter

That returns a number, how's that going to tell you that it's a tuesday?

David_Singleton

DenSter wrote:

That returns a number, how's that going to tell you that it's a tuesday?

Easy:

MyWeekDay := DATE2DWY(MyDate,1);
AnyDate.SETRANGE("Period Type",MyDate."Period Type"::Date);
MyDate.SETRANGE("Period No.",MyWeekDay);
MyDate.FINDFIRST;
MESSAGE('Today is a ' + MyDate."Period Name");

\:D/

Savatage

Weekday = var type text

WeekDay := FORMAT("YOUR DATE",0,'<Weekday Text>');
8)