The name of the day through a date function

This forum is for eXpress++ general support.
Post Reply
Message
Author
Diego Euri Almanzar
Posts: 155
Joined: Thu Nov 05, 2020 10:51 am
Location: DOMINICAN REPUBLIC

The name of the day through a date function

#1 Post by Diego Euri Almanzar »

Hi!

How do I get the name of the day through a date function?

I have 7 tables to store employee hours per day. Table 1 is for Monday, Table 2 is for Tuesday, etc. I want to replace the punch clocks.
For that, I have to get a function that returns the name of the day. For example: Friday, September 17, 2021

I need help.

skiman
Posts: 1183
Joined: Thu Jan 28, 2010 1:22 am
Location: Sijsele, Belgium
Contact:

Re: The name of the day through a date function

#2 Post by skiman »

Hi,

CDow( <dDate> ) --> cNameOfDay

When you search for DAY in the help, and then click on 'see also' you get all the functions that are related to day, and you can click on 'Date functions'.
Best regards,

Chris.
www.aboservice.be

Diego Euri Almanzar
Posts: 155
Joined: Thu Nov 05, 2020 10:51 am
Location: DOMINICAN REPUBLIC

Re: The name of the day through a date function

#3 Post by Diego Euri Almanzar »

Thanks, Skiman.

Best regards.

User avatar
Auge_Ohr
Posts: 1405
Joined: Wed Feb 24, 2010 3:44 pm

Re: The name of the day through a date function

#4 Post by Auge_Ohr »

hi,

for DATE() / TIME() Function read also about SetLocale()

you got Constant NLS_* to configure Display Format
greetings by OHR
Jimmy

Diego Euri Almanzar
Posts: 155
Joined: Thu Nov 05, 2020 10:51 am
Location: DOMINICAN REPUBLIC

Re: The name of the day through a date function

#5 Post by Diego Euri Almanzar »

Excellent data, very useful, Jimmy.

Best regards.

Post Reply