Good afternoon, I ask you for help to do the following:

I currently have an employee control application with the dates and times of entry and exit. In the database made in Google sheets add a column with this formula =SI(DAY(B2)<=15;" FIRST ";"SECOND “)&“FIFTNIGHT OF “&TEXT(MONTH(B2);”#0” )&” FROM "&TEXT(B2;“YYYY”)

Because I need that column to identify which fortnight of which month that row belongs to. But it doesn’t work in the app.

Can somebody help me? I don’t understand very well the language of Glide

Your formula is wrong… what are you trying to do?

Try this:

`=IF(DAY(B2)<=15,"FIRST ","SECOND ")&"FIFTNIGHT OF "&MONTH(B2)&" FROM "&TEXT(B2,"YYYY")`

In Glide, you can use the math column day(date)… month(date)… year(date)… then apply with IF-ELSE column… then use results in the template column

Also, in Glide, you can use an Excel column… pass there this formula:

`IF(DAY(a1)<=15,"FIRST ","SECOND ")&"FIFTNIGHT OF "&MONTH(a1)&" FROM "&year(a1)`

Thank you very much for your help. But I think I’m doing something wrong since I apply the excel formula but it doesn’t calculate.

I command example image.

Hello, you could try to perform the computation within Glide Tables. Would that be an option?

What are you try to do: you have a list of dates and for each row you would like an output of 1 if the date is between the 1st and 15th of the month and an output of 2 if the date is between the 16th and end of the month?

Sure, that’s right. I have to do the calculation inside the slip tables.

Now I add an example image made in a spreadsheet so that the format is better understood, this is to be able to filter by fortnight within the application

Here is an example of how it could be done **in Glide Tables**.

**DAY(Date)**

**DAY(LastDay(month))**

**Fortnight**

**MONTH(Date) with Luxon**

**Year(Date)**

**FortnightDisplay**

NB. I didn’t use the column `MONTH(Date) with Math`

but I could have by creating a relation from that column to a separate table that would map each month to its number and then pulling in the name of the month with a lookup column.

I’m perfect!! thank you very much for your help.

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.